To restrict certain users from connecting to Business Central Online from Power BI, you can manage this either through Business Central permission sets or via Azure Portal. Here’s how you can approach both methods:
Method 1: Using Permission Sets in Business Central
Create a Custom Permission Set:
Go to Permission Sets in Business Central.
Create a new permission set that restricts access to the data entities used by Power BI.
Ensure that this permission set does not include permissions for the tables and pages that Power BI uses to fetch data.
Assign the Permission Set to Users:
Assign the custom permission set to the users you want to restrict.
Remove any other permission sets that might grant access to the data entities used by Power BI.
Method 2: Using Azure Portal
Conditional Access Policies:
Go to the Azure Active Directory in the Azure Portal.
Navigate to Security > Conditional Access.
Create a new policy that targets the users you want to restrict.
Set the conditions to block access to Business Central from Power BI.
Application Permissions:
In the Azure Portal, navigate to Azure Active Directory > Enterprise applications.
Find the Power BI application.
Under Permissions, configure the permissions to restrict access to Business Central for specific users or groups.
Steps for Conditional Access Policy
Create a New Policy:
Name your policy (e.g., “Restrict Power BI Access to Business Central”).
Under Assignments, select the users or groups you want to restrict.
Cloud Apps or Actions:
Select Cloud apps and choose Business Central.
Conditions:
Configure conditions such as device platforms, locations, or client apps if needed.
Access Controls:
Under Grant, select Block access.
Enable Policy:
Enable the policy and save it.
Final Considerations
Testing: Before applying the restrictions broadly, test the configuration with a few users to ensure it works as expected.
Documentation: Document the changes made for future reference and for other administrators.
Share
Report
4
All responses (
Answers (
