Can one save tables in PowerBi to CSV or Excel files?

[Meknowsnothing]

I got a pdf document with many tables. I need to have those either on excel or csv files. Can I do such a conversion by PowerBi? I found that I can read the data to PowerBi tables. But is it possible to save for example table1 in PowerBi to table1.csv? And can I do it automatically as I have over 150 tables and I need over 150 excel or csv files? Or do I need some other tool to convert pdf-tables to excel sheets?

[Icey · Accepted solution]

Hi @Meknowsnothing ,

You can use DAX Studio to export all tables. You can refer to this blog: Exporting all data from a Power BI data model.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Aydeedglz]

Hi I have an error that says 

The connection cannot be used while an XmlReader object is open

what is it?

[mussaenda]

Hi @Meknowsnothing 

If you will just used power bi for file conversion, I am suggesting you to use different programs or online conversion though you can still use Power BI by following @deldersveld suggestion.

[deldersveld]

You can manually copy the results from the Data window in Power BI Desktop using Copy Table and paste into Excel. You cannot do this automatically.