Forum Discussion
How to find data sources ?
Hello, We have some existing Power BI reports, and we want to find which are their data sources. First we tried to find them through https://app.powerbi.com, but it seemed that it was not possibl...
Hi Anonymous
Once you have the PBIX open, click on Edit Queries and then data source settings
This will then show you all the data sources in your PBIX file.
- Hi there
You might be able to use the Vertipaq Analyzer to do this, which will show you the size of your tables and the associated columns.
https://www.sqlbi.com/tools/vertipaq-analyzer/
I am not sure of any other way to get out the requirements you need. I know that the above will show you the columns and tables, but it will not show you the source files unfortunately.
Hi Anonymous
Once you have the PBIX open, click on Edit Queries and then data source settings
This will then show you all the data sources in your PBIX file.
hi GilbertQ
Thanks for your advice, but "Data source settings" can only show the folder where are the source files. I would like to search for more accurate information, like which column corresponds to which column or to which caluclation from which source file.
- Hi there
You might be able to use the Vertipaq Analyzer to do this, which will show you the size of your tables and the associated columns.
https://www.sqlbi.com/tools/vertipaq-analyzer/
I am not sure of any other way to get out the requirements you need. I know that the above will show you the columns and tables, but it will not show you the source files unfortunately.