export to postgres using R or python - need script? cannot type in board??

[v-deddai1-msft]

Hi @se2 ,

You can refer to Exporting Data from Power BI Desktop to SQL Server with R

As a workaround, you can export the data from power bi desktop by DAX studio to csv file : https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-an...   and then load data from csv file to postgres: https://hakibenita.com/fast-load-data-python-postgresql

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

Best Regards,

Dedmon Dai

[se2]

Hi, I see that people are connecting power bi to postgresql, so that they can use power bi to query the data.  I would like to do the opposite, to to send a largish table (189,000 rows) from power bi to a postgreSQL table.  I thought using R or python might help.  Does any know how to do this?  Thanks, SE.

[Anonymous]

Hi @se2 : I havent done this before but found this resource online, Have a read of this:

https://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

It might be of some help. Please share if you able to achieve what you after.

Cheers,

-Namish B