Anaplan Connector issue after March 2025 Power BI Update

[HansD]

Hello,

I would like to ask for assistance regarding an issue that has occurred in recent days. The tables exported from Anaplan are not being loaded properly into Power BI when there is no data in the first row.

For example, as shown in the screenshot below, when only the first row contains a value, only the first column is loaded into Power BI. We have noticed that this issue affects only users who have the March 2025 update of Power BI Desktop installed.

Could someone please advise on how to resolve this issue—ideally without having to rebuild the export action?

Thank you!
Jan

[V-yubandi-msft]

Hi @HansD ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[V-yubandi-msft]

Hi @HansD ,

Could you please confirm if your issue has been resolved, or if you've raised a support ticket ? 

Regards,

Yugandhar.

[V-yubandi-msft]

Hi @HansD ,

We haven’t heard back from you yet, so we wanted to follow up to see if the solution we provided worked for your issue or if you’ve raised a support ticket.

Your feedback is valuable to us, and we'd love to know if everything was resolved or if you need further assistance. Looking forward to your response.

Regards,

Yugandhar.

[V-yubandi-msft]

Hi @HansD ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

[HansD]

Hi @V-yubandi-msft, I have the same situation as @marianadinf. It is not a csv file but Anaplan export ( using Anaplan connector) where I do not control the source model in Anaplan so the export can not be modified. To manually define rows does not help since only one row is being loaded in Power query...

[V-yubandi-msft · Accepted solution]

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.

[V-yubandi-msft]

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:

1. Add a Dummy Row --  Modify the file by adding a header or data row with dummy values in all columns.
2. 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.

[marianadinf]

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?

[marianadinf]

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)

[Sarrah]

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

[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

[HansD]

Thank you for the explanation. Coudl you please explain what do you mean by manually define columns in Power Query? 

[V-yubandi-msft]

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..