Forum Discussion
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 after uploading the report in Power BI Service and setting the scheduled refresh, the following error occurred.
Would you please give me some advice to resolve this issue?
[ValidateMarkupTags][ccon]Expression.Error: The key didn't match any rows in the table.. Key = [ccon][Name = "CRONUS USA, Inc."][/ccon]. Table = [ccon]#table({"Name", "Display_Name", "Data", "ItemKind", "ItemName", "IsLeaf"}, {})[/ccon]. [/ccon];[ccon]The key didn't match any rows in the table.[/ccon]. The exception was raised by the IDbCommand interface. Table: G_LEntries
Thank you very much.
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.
2 Replies
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.
Hi RossEdwards
Thank you much for your help.
You are absolutely right.
After input usename and password again in PowerBI Service.
It works well now.
Thank you very much.
