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...
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.
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 !