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.
Hello
I'm having similar issue, unfortunately we dont control the source of the model so we cant do this workaround. Powerbi should ensure it is backward compatible, that same export with same type of data has been working for 1 year, please can you review?
In my case only the first column get picked up when have more than 10+ since the March 2025 version usinag Anplan connector (not the csv export but an export function)
Hi,
We are encounting exactly the same issue with our data import from the connector Anaplan.
Did you find a solution?
Thank in advance,
Sarrah
Hello everyone,
This issue seems to be due to the Anaplan's export format when you have dimension in Page and layout Grid. With Power Bi march version we have to layout Tabular Multiple Column.
Sarrah
