topic Re: Error with Publishing Dataflows in Dataflow

Error with Publishing Dataflows

ccaudill — Thu, 19 Dec 2024 16:10:11 GMT

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

Re: Error with Publishing Dataflows

qilson — Thu, 19 Dec 2024 16:12:03 GMT

i am also having this issue

Re: Error with Publishing Dataflows

Anonymous — Fri, 20 Dec 2024 08:52:04 GMT

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 Team

Re: Error with Publishing Dataflows

ccaudill — Fri, 20 Dec 2024 15:01:01 GMT

Much appreciated, thank you.

Re: Error with Publishing Dataflows

miguel — Fri, 20 Dec 2024 22:30:37 GMT

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 ?

Re: Error with Publishing Dataflows

ccaudill — Mon, 23 Dec 2024 14:47:47 GMT

Below is a screenshot that articulates the columns and their data types before and after the two query steps of the dataflow

Re: Error with Publishing Dataflows

miguel — Mon, 23 Dec 2024 15:55:58 GMT

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

Re: Error with Publishing Dataflows

Anonymous — Tue, 24 Dec 2024 09:18:23 GMT

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 issue

If you found this post helpful, please consider marking it as "Accept as Solution" to help other members find it more easily.

Thanks,
Pavan.

Re: Error with Publishing Dataflows

Anonymous — Fri, 27 Dec 2024 04:29:40 GMT

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.

Re: Error with Publishing Dataflows

Anonymous — Tue, 31 Dec 2024 12:28:12 GMT

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.

Re: Error with Publishing Dataflows

Anonymous — Fri, 03 Jan 2025 05:03:23 GMT