Forum Discussion
Shpongle
Helper III
Helper IIIExtract report from dataset and connect to another data set
Hi gang, I have a weird one... My company asked me to make some reports and gave me a direct connection to a source SQL database that I used to create my local dataset. Interesting request, t...
- Create your Power BI dataset file. This is a PBIX file with all of your Power Query modeling, the DAX model, and all measures.
- Publish it.
- Create a new PBIX file and connect to the Power BI Dataset. It will only have the visulization/report tab. If you need to make changes to measures, you have to go back to #1 and make those changes and republish.
If you already have reports, you can copy all visuals to a new report that is already connected to the dataset and they will all work.
PowerBiRajah
Advocate I
Advocate II have created a powershell script that creates a new PBIX file with just the reports in it from a pbix that is the dataset. I have found it a lot easier than to do this whole process manually. https://github.com/rajrao/mypublicnotes/blob/master/PowerBi/ConvertDatasetPbixToReportsOnly.ps1