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.
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
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?
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.
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.
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.