web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / I cannot select Micros...
Small and medium business | Business Central, N...
Answered

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

(9) ShareShare
ReportReport
Posted on by Joseph.Candava 183
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 (10)
  • Verified answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 11,612 Super User 2026 Season 1 on at
    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
  • Joseph.Candava Profile Picture
    Joseph.Candava 183 on at
    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.
  • DC-19111412-0 Profile Picture
    DC-19111412-0 7 on at

    Hi everyone,

    The Dynamics 365 Business Central connector in Power BI Desktop has stopped working recently.

    When selecting Business Central as a data source, the connector fails immediately with:

    DataFormat.Error: There were more columns in the result than expected.

    This is happening before the Navigator opens, so it’s impossible to select tables.

    Several users (and MVP posts) have confirmed this is a BC metadata change that Power BI Desktop and Service are rejecting.

    Workarounds like OData v2/4 and custom API endpoints work, but the native connector is currently unusable.

     

    Questions:

    1. Can Microsoft confirm this is a known incident?
    2. Is there an ETA for a fix?

    This is affecting multiple organizations and breaking standard reporting workflows.

    Thanks

  • FinanceFarmer Profile Picture
    FinanceFarmer 24 on at
    This problem is totally unacceptable!
    How can the impact of the change not been tested properly before release into production environments?
    It seems to have equally impacted both the most recent 27.1 version of BC, AND prior versions running on Microsoft cloud. 
     
    The PBI reports impacted (all of them!) all use the legacy Odata connections for data extraction- 
    However, the connections were set up using the PBI/BC connector- Regardless, the reports still fail.
     
    When using the connector, even on a clean, new PBI report, it cannot even return a list of the available data endpoints.
     
    the message "There were more columns in the result than expected" is returned.
     
     
     
  • FinanceFarmer Profile Picture
    FinanceFarmer 24 on at
    This issue seems to be resolved as of a few hours ago by microsoft.
     
    Unfortunately, now PBI service managers everywhere in organizations using BC data will have to restart all the paused refreshes that Microsoft compulsory stopped because of the repeated failures yesterday
     
    Happy clicking everyone!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,421 Super User 2026 Season 1 on at
  • CU19111702-0 Profile Picture
    CU19111702-0 7 on at
    Unfortunately, now PBI service managers everywhere in organizations using BC data will have to restart all the paused refreshes that Microsoft compulsory stopped because of the repeated failures yesterday
     
    Could you please confirm is that Issue is resolved or not.
  • AS-24110619-0 Profile Picture
    AS-24110619-0 4 on at
    I am encountering the same error as well. Could you please share an estimated timeline for when this issue will be resolved?

  • SM-25110341-0 Profile Picture
    SM-25110341-0 4 on at
    I am facing the same issue. Is it resolved yet? Is there any resolution for this?

  • CB-25112132-0 Profile Picture
    CB-25112132-0 10 on at
    I am still getting this issue. Cannot connect using the Online Service or Odata. Are there any updates on this?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans