Export data from Power bi service

[Anonymous]

Hi,

I am trying to export the data from Power BI serive into Excel. I am not sure if this is possible.

Please let me know if there's a way to do that.

[Icey]

Hi @Anonymous ,

Could "Analyze in Excel" meet your requirements? 

If it could, please accept @parry2k 's reply as a solution so that people who may have the same question can get the solution directly.

If not, please let us know.

Best Regards,

Icey

[Anonymous]

@Icey @parry2k It didn't work since I'm not able to move the columns to the value section for pivot table. It gives me an error that it's not supported.

[Anand24]

Hi @Anonymous ,

You can probably keep a table visualization in your dashboard and export the data to .csv format.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[negi007]

@Anonymous  I suggest you to create a Matrix or Table visual in your powerbi dashboard. Using this visual, user will get option to download the raw data in excel format. On the powerbi dashboard, user will have to click on the 3 dots icon and there he/she will get option to export raw data file. 

[amitchandak]

@Anonymous ,

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/

[Anonymous]

@amitchandak @parry2k 

I want to export the data from dashboard. not from the visuals but I want the user to be able to download the raw data.

[parry2k]

@Anonymous unfortunately you cannot do that. Why not use Analyze in Excel and let the user connect to the model and use the data.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

@parry2k  Is there a link for that? I have never done it so if I can get an idea what do I need to do exactly that will be very helpful

[parry2k]

@Anonymous here you go.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Anonymous you can click on top right corner of the visual (3 dots) and there is an export option.

There is a limit on how much you can export. Read here

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡