Forum Discussion
Data source management for reports in all workspaces
Hello, I have several workspaces, each workspace has multiple reports, and each report extracts data from multiple tables, although all tables (in all reports and workspaces) reside in the same SQL s...
Hi there
Have you had a look at the Shared Datasets feature?
What this will allow you to do, is for all reports to connect to this single shared dataset?
Then when you have to make any changes you can just make it to one dataset?
Here are more details on shared datasets: https://docs.microsoft.com/en-us/power-bi/service-datasets-across-workspaces
Have you had a look at the Shared Datasets feature?
What this will allow you to do, is for all reports to connect to this single shared dataset?
Then when you have to make any changes you can just make it to one dataset?
Here are more details on shared datasets: https://docs.microsoft.com/en-us/power-bi/service-datasets-across-workspaces
Thanks Gilbert. But this feature allows me to create multiple reports across multiple workspaces from one single dataset (in my case, a single database, multiple tables). But my circumstance now is after the fact. All these PBI reports have been created and I want to identify all the tables in the one SQL database that impact the reports in these workspaces. How can I identify them? Perhaps I am not understanding this well. Thanks.
- Hi there
What I would then do is to run Query Profiler on the SQL database when the refreshes are happening to see which tables are being queried.Thanks Gilbert. I will try that and let you know !