Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"}),
Solved! Go to Solution.
Hi @hittony
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 @hittony
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.