Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I uploaded some data a few months ago into PowerBI from a massive excel spreadsheet (175k rows). The source spreadsheet is now corrupt but the data is still there in PowerBI. Is there any way I can download the data (via power query or from within PowerBI) so I don't have to try and recreate my original spreadsheet? (help!)
Thanks in advance!
Solved! Go to Solution.
@Anonymous,
In data view of Power BI Desktop, right-click your table and select "Copy Table", then you can paste the data into Excel.
Regards,
Lydia
@Anonymous,
In data view of Power BI Desktop, right-click your table and select "Copy Table", then you can paste the data into Excel.
Regards,
Lydia
Aha! Thank you. I was hoping there was an easy way to do this. Much appreciated.
Hi @Anonymous
1. Download the PBIX file from Power BI Service (Under DataSet)
2. Download DAX Studio (SQLBI) and install it.
3. Now, Open Downloaded PBIX File. But, don't refresh it.
4. Now, Open DAX Studio, Select Power BI File Name from the drop down (Usually, it auto picks the file name)
5. Now, use function Evaluate table name.
6. Now, you will get data in Grid View From there, you can save the results from the menu.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |