Forum Discussion
How to get sql script from power bi workspace
I am in the power Bi work space and I need to get the sql script behind the report not the data. How I can get that? where to find the script?
Yes, you need to download the pbix file and open Power Query to check the source at The Applied steps.
another way maybe is to open the report in the desktop and
and then open the file with a Notepad
4 Replies
Hi Anonymous
I don't think there is a sql script that you can get. the most you can get is a pbip project of the report
Save the report as a pbip
you get folders with files in json
Evertime I am working with power bi report I use sql script get the data from our data warehouse but there are some reports published in power bi workspace by other person and I want to see their sql script that they used to get the data. The person is no longer working there anymore. I have admin rule so is there anyway to get around that?
Yes, you need to download the pbix file and open Power Query to check the source at The Applied steps.
another way maybe is to open the report in the desktop and
and then open the file with a Notepad