Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |