Dataflow - Failed to analyze issues in the query

[Dataplumber]

Whilst saving a dataflow the error Dataflow - Failed to analyze issues in the query appears and does not let me save or keep my work or anything. The problem seems to be sporadic and related to the size of data (largestg table are below 2.6 M rows).
I dont want to think this is a MS Trick to force us to buy Fabric, as these size of data used to be perfectly managed by standard Pro licensing!!!

[Akash_Varuna · Accepted solution]

Hi @Dataplumber Could you try splitting the load to multiple Dataflows maybe and try to push transformations to source as much as possible if applicable

[V-yubandi-msft]

Hi @Dataplumber ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

[V-yubandi-msft]

Helo @Dataplumber ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

[V-yubandi-msft]

Hi @Dataplumber ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft · Accepted solution]

Hello @Dataplumber ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

The issue you’re experiencing with saving the dataflow is likely due to query complexity, dependencies, or data size limitations in Power BI Pro. Based on my understanding, following these steps should help resolve the issue.

1. Manually refresh linked tables in Manage Connections to ensure they load correctly. If any linked tables fail, reload them in their original dataflows first.
2. Use Query Dependencies in Power Query to identify any broken or circular references.
3. Minimize the use of computed tables that depend on linked tables and avoid creating excessive dependencies between dataflows.
4. Disable all queries except one, attempt to save, and then re-enable them one by one to identify the problematic query.
5. Apply filters to large tables to reduce data volume and test saving again to determine if size is the issue.
6. Copy queries individually into a new dataflow to isolate and pinpoint the cause of the error.

I found a similar issue in the community and attached it. It might be helpful, please take a look.
Link: Solved: Dataflow Error: Failed to analyze issues in the qu... - Microsoft Fabric Community

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[Akash_Varuna · Accepted solution]

Hi @Dataplumber Could you try splitting the load to multiple Dataflows maybe and try to push transformations to source as much as possible if applicable