cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hittony
New Member

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 possible (really it's impossible ??). Then we download the .PBIX file from Datasets, and opened it with Desktop. We picked the main query "Data input",  and in Query Editor > Applied Steps > Navigation, we saw a list of EXCEL files, but which one ? or ones ?

 

Thanks for your help

 

The first rows in Advanced Editor :

 

let
    Source = SharePoint.Contents("Company SharePoint root URL", [ApiVersion = 15]),
    #"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
    PowerBI = #"Shared Documents"{[Name="PowerBI"]}[Content],
    #"Data Input" = PowerBI{[Name="Data Input"]}[Content],
    #"Filtered Hidden Files1" = Table.SelectRows(#"Data Input", each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from Query1", each #"Transform File from Query1"([Content])),
    #"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File from Query1"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Query1", Table.ColumnNames(#"Transform File from Query1"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{"All columns"}),

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: How to find data sources ?

Hi @hittony

 

Once you have the PBIX open, click on Edit Queries and then data source settings

 

image.png

 

This will then show you all the data sources in your PBIX file.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

Super User IV
Super User IV

Re: How to find data sources ?

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: How to find data sources ?

Hi @hittony

 

Once you have the PBIX open, click on Edit Queries and then data source settings

 

image.png

 

This will then show you all the data sources in your PBIX file.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

hittony
New Member

Re: How to find data sources ?

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.

Super User IV
Super User IV

Re: How to find data sources ?

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications