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

[Sergin]

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

 
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

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

[Syndicate_Admin]

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?

[Anonymous]

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

[Anonymous]

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

[lbendlin]

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