VIDEO
HIGHLIGHT
Log InSign up
Switch a Power BI Report's dataset without needing Premium!
SummaryTranscriptChat

Switch a Power BI Report's dataset without needing Premium!

Moving a Power BI Report from One Workspace to Another

In this video, Patrick from Guyana Cube demonstrates how to move a live-connected report from one workspace to another and reconnect it to another data set using the Power BI desktop.

Connecting to Production Data Set

  • To switch between data sets in the Power BI desktop, go to Transform Data and select Data Source Settings.
  • Choose the data set that is already published out to production and click Connect.
  • Ensure that the schema is the same between those two data sets because if they are different, things might not work as expected.

Publishing Report to Production

  • Save your changes and publish the report out for production.
  • The new report will appear in your workspace in production.

Conclusion

  • You can use the Power BI desktop instead of writing PowerShell code to switch between data sets when moving a live-connected report from one workspace to another.
  • Make sure that the schema is consistent between data sets before switching them in order for things to work properly.
Video description

Want a dev and production environment in Power BI but don't have Power BI Premium? Patrick shows you a way to switch a report from Dev to Production without Premium or without APIs. 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.com/patrickdba -- http://www.facebook.com/guyinacube -- https://www.instagram.com/guyinacube/ -- https://guyinacube.com ***Gear*** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #Desktop #GuyInACube