Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
aitorNAV
Regular Visitor

Problem with business central DataSource

Hi everyone,

 

A few weeks ago, we created an integration of powerBi and business central. The scheduled refresh was working correctly, until we received this error:

aitorNAV_0-1593009712449.png

 

In the desktop powerBI app, I tried to connect again to business central, and I get this:

aitorNAV_1-1593009800840.png

"Unexpected error: The specified method is not compatible"

 

 

 

We didn't made any aparent changes on our developments in  BC.

 

Any hint avbout this issue?

 

Thank you all

7 REPLIES 7
jmarek31
Frequent Visitor

What version of of Business Central are you on? The one I am working on is 16.2 and has the same issues. So I am thinking it is an issues with the version of BC and the connector in Power BI do not work together. I am trying to see if there is a fix some where to get connected but cannot find an update for Power BI or a change for BC.

Hello,

 

I am also using 16.2, it's a SaaS installation, so it's always upgraded.

I can't believe that this might be a problem, but lokking ot the results I've had from different test, I can't discard it....

I've tried to connect via oData to the non-standard web services of that tennant, without any problem.

It's quite strange, but it's an important problem....

Hi everyone,

 

I've unpublished the webSerivces, and published them again, and at first time, still didn't work. But after a time, suddenly started working again... Quite strange, but well, it's working now...

parry2k
Super User
Super User

@aitorNAV can you see other tables available in the BC? Seems like something changed at the endpoint, not sure if it is this particular table or it is a connection.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thanks for your answer @parry2k .

 

I get this error if I try to use business entral as dataSource. Instead of that, if I try to use oData as data source, and add the only oData service that is not in the standard, I didn't get the error. So i understand that the problem is not in that table.... I admit that I am quite lost

@aitorNAV can you start a new pbix and test odata to see if you can connect and then we can come back to existing report. First and foremost you have to connect to data source and see if you can pull the tables.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

I am opening the powerBI without without any pbix,  I'm using a new one jsut for testing the sources....

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.