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 ,

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]

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)

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