SQL for a power bi table

Question

Hi Team, Is there any way to see the sql behind a power bi table.

I am connecting to a oracle db using power bi service with multiple tables connected to the power bi report. Have created a table view with help of multiple tables and now i want to improve the performance of the table query.

Please advise.

Thanks,

Bhushan

amitchandak · Answer

Anonymous , Check if this can help
https://community.powerbi.com/t5/Desktop/How-to-get-SQL-query-for-report/td-p/459830

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;Try ODBC or OLE DBhttps://community.powerbi.com/t5/Desktop/Connect-To-Oracle-Database-in-Power-BI/td-p/248114&nbsp;https://community.powerbi.com/t5/Power-Query/Oracle-connection/td-p/1039732&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Thanks for the response, Amit.&nbsp;The solution doesn't help me to view the final query of the formatted table which uses joins in power bi desktop.&nbsp;Please assist.&nbsp;

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;Is this problem sloved?If not, please let me know.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Thanks for the follow up,Liang.&nbsp;Nope, I am still not able to view the sql.

Forum Discussion

SQL for a power bi table

7 Replies

Related content

Native SQL query for Power BI

Truncate Warehouse SQL table

Power Query or SQL

Matrix table in Power bi

UDF writeback text to SQL table