Forum Discussion

Zhangyi's avatar
Zhangyi
New Member
2 years ago
Solved

Error when loading data from Business central in Powerbi Service

Hi everybody:   I have created a report to load data from the General Ledger Entry table in Business Central by API. The data load is fine when I click the refresh button in Power BI Desktop. But...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Is the Source Authentication username/password the same in your Power BI Desktop when compared to the one that was registered in Power BI Service?

     

    I wonder if your Power BI Service registered username does not have access to that data.

     

    For example, you might be using an admin user account when you connect to the database but when you created a gateway entry in the service, you might have used a "Business Viewer" named account which is heavily restricted.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Is the Source Authentication username/password the same in your Power BI Desktop when compared to the one that was registered in Power BI Service?

 

I wonder if your Power BI Service registered username does not have access to that data.

 

For example, you might be using an admin user account when you connect to the database but when you created a gateway entry in the service, you might have used a "Business Viewer" named account which is heavily restricted.