How to document all Get Data datasources in a .pbix & On premises gateway

[DavidMoss]

Is there a quick way to extract all the datasources from a single .pbix file. Just i am documenting a report and need to quickly extract them all (20+) When i mean datasource i mean the connecting string.....which are like the first 3 lines in the advanced query editor.

Source = Sql.Databases("1n.n.0.nn"),
Reporting = Source{[Name="Reporting"]}[Data],
dbo_MonthlySales = Reporting{[Schema="dbo",Item="MonthlySales"]}[Data],

you know how there is DAX studio for extracting & working with the datamodel & measures ...is there something similar to extract all the Power Query/Get Data datasources ?

Also would help if we could extract all the datasourcesfor the "Manage GAteway".

That way i can run a quick check that all data sources are set correctly on the GAteway and checck them against the list oof data sources in the .pbix file...

Any suggestions out there plese ??

[DavidMoss · Accepted solution]

Awesome witha bit of searching on the forum and thanks to @ImkeF i found some answers for extracting the whole PBI advanced queries for the .pbix file. Thats saved loads of time.

See the discussion here

Tools now using are:

send a frown to extract PBI advances editor source code

sankey reports

dax studio

Still looking for a solution to extract OnPremises gateway settings if you know of one ????