"EnableCrossDatabaseFolding' with value 'true'" I am receiving this error even after adding Gateway'

[ThanujaBhartha]

Hi,

I am trying to store my historic data in a newly created Azure DB using this Dataflows Gen2. So for this dataflows as a source I am pulling the information from another dataflow from powerBi workspace which has not been refershed for more than 2 years and is not supposed to get refrshed.
So, My plan is to dump the historic data from that dataflow to this Gen2 Datflow and then dump in it newly created Azure Db. But when try to select the destiation as Azure DB, it throws me this error "An exception occurred: Microsoft SQL: This function doesn't support the query option 'EnableCrossDatabaseFolding' with value 'true'." And I even tried adding gateways but that dint work either.
And the problem is I cannot go and change the query in my original dataflow as I dont want to make changes to the historic data.

Can someone help me with this or any alternative solutions are also welcome for me to store the data in the dataflow in a saferplace along with the structure of the data.

Thanks,

Thanuja.

[ThanujaBhartha]

Hi,

Thanks for checking on me :). Yes, I did raise the support ticket and now the issue is resolved as the problem was my gateways which were not in the latest version. Once I upgarded the version of the gateways, the Gen2 dataflows worked.

Thanks for your support,

Thanuja B.

[v-cboorla-msft]

Hi @ThanujaBhartha 

Thanks for using Microsoft Fabric Community.

Please refer to the relevant thread on the forum which might help you in resolving your query.

Thread link : Solved: Re: Error when selecting data destination in Dataf... - Microsoft Fabric Community

If the issue still persists, please do let us know. Glad to help.

I hope this information helps.

Thank you.

[ThanujaBhartha]

Hi,

I did tried this solution of adding gateway, that dint work and I tried bringing in one table in one dataflow and that too dint work.

Thanks.

[v-cboorla-msft]

Hi @ThanujaBhartha 

Apologies for the inconvenience and the delay in response.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[v-cboorla-msft]

Hi @ThanujaBhartha 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.