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???

[v-yiruan-msft]

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

[v-yiruan-msft]

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).