Write values from Dataflow Power Query into MS SQL Express database (on premises)

[Anonymous]

Hello, 

I have Power Query script in Power BI Service Dataflow, that does SQL INSERT of dynamic values into MS SQL database table. Problem is that script works when executed in Power BI Desktop, and Online Editor (Dataflow), but when I save and run refresh of dataflow nothing happens in SQL database. Power Query that isn't executed in Dataflow is Value.NativeQuery(DatabaseSource, SQLQuery).

Refresh shows as Completed. 

And has anyone succeded in doing something like that?

Advice pls? Thanks

[lbendlin]

At the moment Power BI/ Power Query is not a write-back tool. Hopefully this will change soon.

What's your reason for not using SSIS?

[Anonymous]

Thanks, I know that load part of PQ isn't best, but there are plenty articles describing how to load data from PQ. Do you know if R or Python in PQ have same limitations as SQL? I'm not using SSIS because I'm trying to keep costs to minimum.

[lbendlin]

There are a few articles on this forum about successfully using R scripts for ETL on the desktop.  Not so sure about the service though.