Forum Discussion
Solved
Error with Publishing Dataflows
I am attempting to publish a dataflow that has several different queries to a sql database, I am receiving the error listed below when attempting to publish the dataflow: For query "FactCaseMgmt",...
Assuming that your query has exactly those data types clearly defined and no structured / complex column types, then your FactCaseMgmt query shouldn't have any issues with its schema. At least in theory.
Please raise a support ticket so an engineer and investigate further
Dataflows has a different architecture than the one used to run and evaluate the queries in Power BI Desktop.
could you please tell us what's the schema of the table mentioned in the error message ?
Below is a screenshot that articulates the columns and their data types before and after the two query steps of the dataflow