Business Central's Power BI Permissions After Updating to Version 27.0

(5) Share

Report

Posted on by JE-20081519-0

3,549

Hi:

I'm facing an error, when trying financial Power BI connections after the update to Version 27.0.

I’ve hit a snag to do with permissions.

My research suggests I need access to view and edit the

- - Table Data: G/L Account (15) – Read permission.
  - Page: Chart of Accounts (560) – Access to view the list.

I want to be sure that we only grant me this access not all business manager role users. (Several people have that role and
I certainly don’t want to give them all this level of access.)

Research excerpts:
The error message indicates that Power BI cannot process the dataset because the column G/L Account No. in the table G/L Account contains a duplicate value (110). This is problematic because:

The column is being used on the one side of a many-to-one relationship or as a primary key, which requires unique values.
Duplicate values break the integrity of relationships in the data model.

In Business Central, access to view or edit G/L Accounts depends on the permission sets assigned to a user.

How do I go about addressing this?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (2)

Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

This is a known issue that occurred yesterday.

https://admin.powerplatform.microsoft.com/support/knownissues/5868030

https://admin.powerplatform.microsoft.com/support/knownissues/5867547

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

You just need a custom permission set that gives you:

G/L Account (Table 15) → Read

Chart of Accounts (Page 560) → Execute

Assign this permission set only to your user, not the whole Business Manager role.
This fixes the Power BI connection without giving anyone else extra access.

The duplicate G/L Account error is coming from Power BI, not BC — usually solved by refreshing or cleaning the dataset.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Create a custom permission set in Business Central that grants Read access to Table 15 (G/L Account) and Page 560 (Chart of Accounts), and assign it only to your user instead of modifying the Business Manager role.

For the Power BI error about duplicate G/L Account No., ensure uniqueness by either combining Company Name + G/L Account No. in your data model or verifying that account numbers are unique within each company.

This secures permissions and resolves the relationship integrity issue without impacting other users.

2 people found this reply helpful.

Was this reply helpful? Yes No