topic Re: Error when selecting data destination in Dataflow Gen2 in Fabric platform

Error when selecting data destination in Dataflow Gen2

Charley194 — Tue, 07 Nov 2023 14:07:18 GMT

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

Re: Error when selecting data destination in Dataflow Gen2

AndyDDC — Tue, 07 Nov 2023 15:51:05 GMT

Hi Charley194 is this an Azure SQL Database (not MI). If so, what service tier is the Azure SQL DB set to?

Re: Error when selecting data destination in Dataflow Gen2

Charley194 — Tue, 07 Nov 2023 15:53:31 GMT

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.

Re: Error when selecting data destination in Dataflow Gen2

AndyDDC — Tue, 07 Nov 2023 15:55:29 GMT

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.

Re: Error when selecting data destination in Dataflow Gen2

v-cboorla-msft — Wed, 08 Nov 2023 13:22:47 GMT

Hi Charley194

Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.