Is there a way to view & extract all SQL tables used in Power BI workspaces?

[revathi_p4]

Is there a way to view & extract all SQL tables used in Power BI workspaces?

[dcrosseto]

Hi @revathi_p4,

You mean on the PowerBI Service? If yes, you can see the tables used on the dataset on the right side, but it doesn't indicate the source, could be from SQL, Excel, SharePoint and etc.

If you mean on the Desktop, the only way to see the tables or SQL query is by going on each dataset inside PowerQuery and checking for the tab "Source", like mentioned below.

https://prnt.sc/FvYhDwf63RyJ

I never head of a way to list all my "sources", would love to know it 😊

Hope it was helpful.

Regards,

Douglas.

[revathi_p4]

Thanks for your response. 

Yes,from powerbi service. 

we have more than 100 reports in workspace(each reports connected with different sql table). Exact need here is Need to extract(excel/Json format) all the datasource connected (SQL table name,Database) in dashboard from powerbi services. 

Output:

1st column --> SQL table name

2nd column --> Database name

3rd column--> Powerbi report/Dataset name

Hope Its clear!!

[Shaurya]

Hi @revathi_p4,

I think this post answers your question.

https://community.powerbi.com/t5/Power-Query/Is-there-a-way-to-view-all-SQL-tables-used-in-our-organ...

Works for you? Mark this post as a solution if it does!

Consider taking a look at my blog:Forecast Period - Graphical Comparison 

[revathi_p4]

Thanks for your response. refer this blog already. Its gives only database information..

we have more than 100 reports in workspace(each reports connected with different sql table). Exact need here is Need to extract(excel/Json format) all the datasource connected (SQL table name,Database) in workspace using API

Output:

1st column --> SQL table name

2nd column --> Database name

3rd column--> Powerbi report/Dataset name

Hope Its clear!!