Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Can I get SQL query used to create a dataset in PowerBI using the powerbi report/dataset. I no longer have the desktop file (.pbix).
I only have the report and dataset in PowerBI Service. I had used couple of joins and a couple of where conditions in powerBI desktop. I am trying to recreate the dataset but now I somehow get slightly different version of the dataset.
Can I find the joined tables and where conditions used in the powerBI desktop via the report in powerBI service?
Thank you!
Solved! Go to Solution.
Hi. Just in case remember you can download the pbix file from Service. If you can't find the option, ask your admin to turn that on for you for just an hour to help you with the development.
The only way to read the whole power query code from a dataset at service is if it's hosted on dedicated capacity. Only premium, embedded and PPU workspaces will let you connect with XMLA endpoint to the dataset to read how it's built. If you have one of those licenses then open download and open Tabular Editor. Connect to the workspace, select the dataset and open it. The table contains partitions that will show the whole code like Advanced Editor reading all Power Query.
I hope that helps
Happy to help!
Hi. Just in case remember you can download the pbix file from Service. If you can't find the option, ask your admin to turn that on for you for just an hour to help you with the development.
The only way to read the whole power query code from a dataset at service is if it's hosted on dedicated capacity. Only premium, embedded and PPU workspaces will let you connect with XMLA endpoint to the dataset to read how it's built. If you have one of those licenses then open download and open Tabular Editor. Connect to the workspace, select the dataset and open it. The table contains partitions that will show the whole code like Advanced Editor reading all Power Query.
I hope that helps
Happy to help!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
30 | |
24 | |
23 | |
20 |
User | Count |
---|---|
54 | |
33 | |
22 | |
20 | |
20 |