Forum Discussion

AEIOUandY's avatar
AEIOUandY
Frequent Visitor
2 years ago
Solved

Creating and sharing multiple reports using the same Power BI Service Dataset

I'm currently working on a series of reports that I intended to use a singular dataset hosted on the Power BI Service to populate. That dataset uses a gateway connection to an on-premise SQL server D...
  • AEIOUandY's avatar
    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.