Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Download data from PowerBI - corrupt source

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!

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago

    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.