Forum Discussion
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", Schema evaluation did not return TableResult. Actual result type: Cancellation, Evaluation cancelled, Message: Evaluation is canceled
The confusing part is that I had copied the Query steps from a PBIX file, where it currently runs every day without issue. It is also worth noting that when I attempt to publish, it tries to publish for an hour prior to returning an error message (extremely frustrating)
Would appreciate any help with this
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
10 Replies
i am also having this issue
Hi ccaudill ,
Your question belongs to the Data Factory forum, and I have moved the post to the appropriate forum for you, where a professional will be able to help you.
Best Regards,
Yang
Community Support TeamMuch appreciated, thank you.
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
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
Hi ccaudill
Thanks for reaching out in Microsoft Community Forum
To acheive this error, below are the reasons maybe occurs in power BI or SQL
1. simplify the queries to reduce data volume or break them into small queries
2. Please make sure to provide valid credentials for the SQL database in power BI service
3. please check for any resource limits or power BI service issues that maybe leads to cancellation or timeout issues
4. create the dataflow manually to avoid configuration issues inherited from PBIX file.
5. use the performance analyzer in the power BI desktop to identify the issues in your queries before publishing
6. Review the Admin portal to check whether the issue from queries or perfomance issueIf you found this post helpful, please consider marking it as "Accept as Solution" to help other members find it more easily.
Thanks,
Pavan.Hi ccaudill,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you,
Pavan.Hi @ccaudill,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you,
Pavan.Hi ccaudill,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you,
Pavan.
