Forum Discussion
Anaplan Connector issue after March 2025 Power BI Update
It appears that the issue is related to the March 2025 update of Power BI Desktop, likely due to a bug or an unintended change in the latest version.
Since modifying the export structure from Anaplan is not feasible and manual schema adjustments are not resolving the problem, the best course of action would be to raise a support ticket with Microsoft for further investigation.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Sorry for the delay in response marianadinf .
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
Hi HansD ,
Thank you for reaching out to the Microsoft Fabric Community. Users who updated to the March 2025 version of Power BI Desktop might encounter issues when importing exported data from Anaplan or similar flat file sources. If the first data row contains very few values, Power Query may misinterpret the file, loading only the first column and ignoring the rest.
Work Arounds:
- Add a Dummy Row -- Modify the file by adding a header or data row with dummy values in all columns.
- Manually Define Columns -- Use Power Query to manually define the column structure.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the explanation. Coudl you please explain what do you mean by manually define columns in Power Query?
Hi HansD ,
The official documents linked below offer clear, step-by-step guidelines for manually defining the column structure in Power Query. I recommend reviewing them, as they should help you address the issue effectively.
References :
Promote or demote column headers - Power Query | Microsoft Learn
Split columns by delimiter - Power Query | Microsoft Learn
Thanks..