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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Sergin
New Member

Error when trying to refresh data source on app.powerbi.com

Hello,
I am getting the next message/error (screen below) when trying to refresh the data source

Screenshot_3.jpg


Connect between Business Central and Power Bi, used OData connector instead of standard one for BC. 
the link I use to get lines from table "Segment Lines" https://api.businesscentral.dynamics.com/v2.0/<<mytenant>>/Production/ODataV4//Company('Demo')/Segme...

when I try to use this link in a browser get the next message

Screenshot_4.jpg

Is it possible that the problem can be with the Privacy level, license, role, or maybe an invalid link I use???



4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

I created a report in Power BI a few weeks ago. I call the tables through the Dynamics Business Central connector.

I can bring all the standard boards and update them without any problems.

At the time of creating the report, create a web service with all the necessary data from page 20 General Ledger Entries. At the time of creating the report I had no problems and I was able to view the table in power BI, but today when I want to update the data to bring the information recorded these days I get this error. What could be happening?, How do I fix it?, Is it because of the amount of data?, Do I need a special Power BI license?

ELCABALLERO_BC_0-1708370820257.png

v-yiruan-msft
Community Support
Community Support

Hi @Sergin ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yiruan-msft
Community Support
Community Support

Hi @Sergin ,

Did you try to create Power BI report using the Dynamics 365 Business Central Data? If yes, you can refer the following official documentation.

Building Power BI Reports to Display Dynamics 365 Business Central Data

Based on the error message, it seems to be a data source authentication issue. Please check the method or workaround mentioned in the threads below , hopefully its will help you solve the problem as well.

Error connecting Business Central


The work around I used for this connection problem is the on-premises data gateway, directly connected to my SQL database. I tried using the API but still having a problem during GET and POST.


Seamless integration of Power BI in Business Central

We found a solution that worked - but it required an instance using NavUserPassword and a web services key.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super User

No, the error is that the ODATA service doesn't like your credentials. Has nothing to do with privacy levels (yet).

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.