Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Sql.Database Query option removed in Dataflows

This started happening sometime yesterday and containues. Dataflows that have refreshed daily for months failed, and on investigation, I discovered the Query argument from the Sql.Database options had just been removed. The dataflows do not show they were edited. They're owned by me and still show they're owned by me, and I haven't touched them, but the code itself has changed.

 

qs = "select * from table",
Source = Sql.Database(server, db_Reporting, [Query=qs, CreateNavigationProperties=false])

 

is transformed to

 

qs = "select * from table",
Source = Sql.Database(server, db_Reporting, [CreateNavigationProperties=false])

 

If I edit the entities to replace the missing Query option, it seems to save, but the option is removed again. 

Status: New
Comments
gtacchini
Advocate I

Having exactly the same issue here!! All of the sudden all my dataflow sql native queries are broken! This is critical!!

 

 

pd: I've also noted that when downloading the dataflow Json, all my sql queries have been "pushed" to a document section....

 

 

HELP PLEASE!