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 ,

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