Forum Discussion
Resolver IDataflow fails with error "contains invalid characters. ",;{}()\n\t=" are not supported"
In follow up to my previous message, I have managed to overcome this frustrating issue.
I want to mention that I had already tried dropping the Lakehouse destination table, which didn't resolve the issue. I had also attempted to delete and recreate the destination on the dataflow query, without success.
I then went the route of recreating the query from scratch, literally duplicating the steps one by one, and THEN I set up the data destination. Once I had a duplicate query, I deleted the original query (in the dataflow) and republished and it finally worked.
These kinds of issues are frustrating, as they reveal Fabric's soft underbelly! But a lesson to me (and possibly to others) is, when in doubt, try starting from a clean slate.
Resolver IIn follow up to my previous message, I have managed to overcome this frustrating issue.
I want to mention that I had already tried dropping the Lakehouse destination table, which didn't resolve the issue. I had also attempted to delete and recreate the destination on the dataflow query, without success.
I then went the route of recreating the query from scratch, literally duplicating the steps one by one, and THEN I set up the data destination. Once I had a duplicate query, I deleted the original query (in the dataflow) and republished and it finally worked.
These kinds of issues are frustrating, as they reveal Fabric's soft underbelly! But a lesson to me (and possibly to others) is, when in doubt, try starting from a clean slate.