Download data from PowerBI - corrupt source

[Anonymous]

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!

[v-yuezhe-msft · Accepted 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]

Aha! Thank you. I was hoping there was an easy way to do this. Much appreciated.

[rocky09]

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.