How to export power Bi table to SQL server using python or R?

[Anonymous]

Hello,

i would like to know how to export data from a powerBi table to sql server, ideally i would like to do this via python although R would not bother me (which ever is more sutable).

i reaserched online and i saw a solution from "https://www.biinsight.com/exporting-power-bi-data-to-sql-server/"

However i have a few problems with this:

    It sends the data as strings, how can i send the correct data type instead?

    Empty values do not show as NULL instead it is an empty string, how can i fix this?

    It duplicates values if ran more than once, for this im planning to clear then add the data back in (any other method is wolcome)

any help is appreciated 🙂

[Anonymous]

Hope you have got the answer by now. 😅 Shortcut method here is using an external tool DAX Studio. This solves 99% problem. But sometimes it can give a bug and here you can also use to first export it to csv/xlsx and then import csv/xlsx in SQL Server Import Wizard.

[GilbertQ]

Hi there

Could you not rather export the data from the source before it gets into Power BI?