Error when selecting data destination in Dataflow Gen2

[Charley194]

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 

[AndyDDC]

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

[Charley194 · Accepted solution]

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.

[v-cboorla-msft]

Hi @Charley194 

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

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