Forum Discussion

ccaudill's avatar
ccaudill
Regular Visitor
1 year ago
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",...
Data hub
One Lake
  • miguel's avatar
    miguel
    1 year ago

    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 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.