collect the list of datasources used in all the workspaces

I want a list of the queries in the pbix files



For example : in the report RTS_Shipments.pbix We have 23 queries.

query = qv_rtsshipments_invoicing_pic =>

let

Source = Denodo.Contents("DenodoACC", null),
datahub_Database = Source{[Name="datahub",Kind="Database"]}[Data],
dwhhub_Schema = datahub_Database{[Name="dwhhub",Kind="Schema"]}[Data],
qv_rtsshipments_invoicing_pic_View = dwhhub_Schema{[Name="qv_rtsshipments_invoicing_pic",Kind="View"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(qv_rtsshipments_invoicing_pic_View,{{"inv_date", type date}}),
#"Lignes filtrées" = Table.SelectRows(#"Changed Type", each true)
in
#"Lignes filtrées"



query = qv_rtsshipments_invoicing_pic =>

let

Source = Denodo.Contents("DenodoACC", null),
datahub_Database = Source{[Name="datahub",Kind="Database"]}[Data],
dwhhub_Schema = datahub_Database{[Name="dwhhub",Kind="Schema"]}[Data],
qv_rtsshipments_productioncr_sap_cpp_View = dwhhub_Schema{[Name="qv_rtsshipments_productioncr_sap_cpp",Kind="View"]}[Data],
#"Type modifié" = Table.TransformColumnTypes(qv_rtsshipments_productioncr_sap_cpp_View,{{"pack_packing_date", type date}}),
#"Personnalisée ajoutée" = Table.AddColumn(#"Type modifié", "Semaine de l'année ", each Date.WeekOfYear([pack_packing_date],2)),
#"Type modifié1" = Table.TransformColumnTypes(#"Personnalisée ajoutée",{{"Semaine de l'année ", type text}}),
#"Personnalisée ajoutée1" = Table.AddColumn(#"Type modifié1", "YearWeek", each Text.Combine ({[pack_packing_yearprod],[#"Semaine de l'année "]}))
in
#"Personnalisée ajoutée1"





I try to create a list for each pbix in Power BI for all the workspaces (not my workspace)

something like this....

workspace report query Source Database Schema Name

ASE Activities-Stoc RTS_Shipments.pbix qv_rtsshipments_invoicing_pic DenodoACC dwhhub dwhhub qv_rtsshipments_invoicing_pic

ASE Activities-Stoc RTS_Shipments.pbix qv_rtsshipments_invoicing_pic DenodoACC dwhhub dwhhub qv_rtsshipments_productioncr_sap_cpp

....

Is this possible ?

With this information we can investigate if a report is published in different workspaces and if one query is used in different reports.

If one query is used in different reports we can create a dataflow one time - and load the data one time instead of several times for several reports