Forum Discussion
Error when selecting data destination in Dataflow Gen2
I have built a very simple query in Dataflow Gen2, select * from dbo.table, which returns a small amount of data. There are no steps after this. I am attempting to push this data into an Asure SQL instance. I can select the destination instance but when I do I get this error
An exception occurred: Microsoft SQL: This function doesn't support the query option 'EnableCrossDatabaseFolding' with value 'true'.
The query does not have cross database folding selected so I really stuck on how to solve this problem. Can anyone help please
I dont know, is this something to consider?
Though I have solved the issue now. Update the Power BI gateway and that problem was solved.
4 Replies
- AndyDDC
Most Valuable Professional
Hi Charley194 is this an Azure SQL Database (not MI). If so, what service tier is the Azure SQL DB set to?
I dont know, is this something to consider?
Though I have solved the issue now. Update the Power BI gateway and that problem was solved.- AndyDDC
It's certainly something to confirm, I never know whether certain features work with certain editions/tiers of SQL Databases. Glad you found the solution though, great news.
