Forum Discussion

Sachy123's avatar
Sachy123
Icon for Helper V rankHelper V
5 years ago

Export Data from Power BI (Matrix) into Excel

I have data in power bi in a Matrix form. ate X Y Z A 2020-11-30 20 5 2 100 2020-10-30 10 15 20 10   But when I export the data  , it gets exported in the following format ...
Need Help
Show and Tell
Sachy123's avatar
Sachy123
Icon for Helper V rankHelper V
5 years ago

Thanks!

its a nice tool but it doesnot dump the data as it is from Power BI. It creates the replica of the dimensions and tables used but I need an exact data dump.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Sachy123 

    Not possible as data, 
    but it should be fairly easy to replicate the matrix using the tool offered by sqlbi.com