I cannot select Microsoft Business Central as my data source in Power Bi lately.

(2) Share

Report

Posted on by Joseph.Candava

156

Is it just me or whenever I go to Home tab, then Get data then More... then on Online Services when I select "Dynamics 365 Business Central" I would get this error message?

Unable to connect

We encountered an error while trying to connect.
Details: "There were more columns in the result than expected."

I would get these similar looking errors regardless if I am working on an existing Power Bi report that is connected to Dynamics Business Central or starting completely from scratch without getting any opportunity to "filter out my 7+ columns" from the error message.

DataFormat.Error: There were more columns in the result than expected.
Details:
    Count=7

I don't believe it is because of my Power Bi Desktop version, as I have heard others using slightly older builds reach similar errors as mine.

For troubleshooting, I did click on Edit and attempt to insert my Production environment, tenant values and other parameters to be met with the same error message.

Is this happening to you too?
If you found a solution to this, your help will much be appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

OussamaSabbouh 3,066 on at

Like (1)

Report

I cannot select Microsoft Business Central as my data source in Power Bi lately.

Hello,

This is a widespread issue with the Power BI → Dynamics 365 Business Central connector.
The connector is currently broken because BC started returning extra metadata columns, and Power BI Desktop rejects them with:

“There were more columns in the result than expected.”

It’s not your version, not your settings — everyone is seeing this right now.

The BC connector in Power BI Desktop is temporarily broken.

Caused by a Microsoft-side change in BC/connector metadata.

You can’t fix it locally.

Workaround

Use OData or API endpoints instead until Microsoft patches it.

Example OData:

https://api.businesscentral.dynamics.com/v2.0/<tenant>/<env>/ODataV4/Company('MyCompany')/Customer

It works reliably.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Joseph.Candava 156 on at

Like (0)

Report

I cannot select Microsoft Business Central as my data source in Power Bi lately.

I can confirm OData Feeds does work for brand new Power Bi reports when introducing new data sources to the report.

How do I update existing data sources to switch from the Dynamics Business Central connector and into OData Feeds in Power Query? I have many existing reports that has many applied steps that I will have to reconstruct from scratch if there is no such possible way to swap the source while preserving the existing steps.

Was this reply helpful? Yes No

Join the conversation

Community site session details

I cannot select Microsoft Business Central as my data source in Power Bi lately.

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

I cannot select Microsoft Business Central as my data source in Power Bi lately.

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates