Forum Discussion
Creating and sharing multiple reports using the same Power BI Service Dataset
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.
I appreciate the reply, GilbertQ. I had already been through that webpage's list of don'ts and it unfortunately didn't help.
Previously when selecting a Power BI Service dataset, we selected the set and that was it - there was no popup to choose the whole set or only selected tables from it. I don't know what implications that has, but noticed the child data model springing up now that this new step has been added. I feel this is not a coincidence. The reports I'm designing are in no way different from what I had previously created and published and embedded to websites using this method. I'm not using RLS on the original dataset. I'm not using ANY additional measures (no report-level DAX measures) in my new reports - the data model is unchanged.
Where SHOULD I see the "Connected live ..." banner? Under the ribbon? I definitely am NOT seeing that and it hadn't dawned on me that something is up with my data connection. When I view the Data Sources, it's listed as a "Direct Query to AS - Power BI Dataset;DatasetName". AS is our org Fabric admin's initials, so I assume that refers to them, and our gateway is setup as an on-prem gateway with me added as a "connection creator with resharing".