Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Export to Excel and View Data

Hi:

Supposedly, if you export data from Power Query to Excel, you can hover over one of Excel's columns and see data from the application that Power BI is connected to.

For example, if Power BI is pulling data from an ERP application, you can export that data from Power Query to Excel, hover over one of the columns, and see the ERP application's data in Excel.

How is this possible?

Thanks!

John

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Please consider doing an ETL the data in the PowerQuery editor, using an external tool in the Power BI desktop. For example DaxStudio, here select the 'static' option to run this query.

    EVALUATE
YourTableName


    The PowerQuery editor does not provide the option to export.

    DAX Studio | DAX Studio

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum