Forum Discussion
Creating and sharing multiple reports using the same Power BI Service Dataset
- 2 years ago
No solution really helped, I had the experience of having some reports from which I removed the data connections for which I WAS able to successfully create a live connection to my master report, and some reports from which I removed the data connections for which I WASN'T able to successfully create a live connection to my master report with all of the previous data removed.
I don't know what differentiated the successes from the failures, my solution was to rebuild the failures by copying the visualizations into a new blank report and THEN create a live connection to the dataset on the PBI Service, and rebuild the bookmarks, tabs, etc. afterward. I had been hoping to avoid the work of setting up all of my navigation again, but lesson learned, I guess. Even though the file SEEMS to remove all data connections, for whatever reason it wouldn't let me establish a live connection afterward, even though I had full access/permissions to do so (and was in fact able to do so with other already populated files (where the data model was deleted) and with brand new files (as would be expected, as no data model had previously existed to conflict with the new one).
I might need to mark this as solved by me but not in the way I was hoping.
Hi AEIOUandY
As far as I know if you had to select the Power BI dataset when connecting it should work without having another child data file.
When connecting to the dataset in the Power BI Service make sure to select "Power BI Dataset"
Then make sure that when you have your report open it says "Connected live to the Power BI Dataset"
If it does not say the above it will create a child data file.
For the publish to web it will not work with the child dataset, you have to connect in the above way. Here is a link to the limitations below.
Publish to web from Power BI - Power BI | Microsoft Learn