Steps to Manage Data Source Permissions for APIs in Power BI Desktop and Service

Today we will learn how to manage data source permissions for APIs in both Power BI Desktop and Power BI Service. This topic is important when you are working with API-based datasets because incorrect permissions often lead to refresh errors or authentication issues.

In real scenarios, many users successfully connect APIs in Desktop but face problems after publishing to the Service. That happens because permissions must be configured separately in both environments.

Why Data Source Permissions Matter in Power BI

When working with APIs, Power BI needs proper authentication and privacy settings to access data securely.

If permissions are not configured correctly:

• Data refresh will fail
• API connection errors may occur
• Reports may not load in Power BI Service

That is why managing credentials and privacy levels correctly is essential.

Watch Complete Video

Watch this quick walkthrough to understand how API permissions are managed step by step in Power BI Desktop and Service.

Steps to Manage API Data Source Permissions in Power BI Desktop

Let’s first understand how to configure permissions in Power BI Desktop.

Step 1 Open Data Source Settings

Go to:
File → Options and Settings → Data Source Settings

Step 2 Select Current File Data Source

• A dialog box will appear
• Choose Data sources in current file

Step 3 Edit Permissions

• Select your API data source
• Click on Edit Permissions

Step 4 Configure Credentials

Set the following based on your API type:

• Credential Type: Anonymous (for public APIs)
• Privacy Level: None

Click OK to apply

Step 5 Verify Settings

• Ensure all API sources are updated correctly before publishing

This step is important to avoid issues later in the Service.

Steps to Manage API Permissions in Power BI Service

After publishing your report, you must configure permissions again in the Service.

Step 1 Go to Workspace

• Open your report in Power BI Service
• Locate your dataset (semantic model)

Step 2 Open Data Source Credentials

• Click on Settings
• Expand Data source credentials

Step 3 Update Authentication

Edit credentials and set:

• Authentication Method: Anonymous (or based on API)
• Privacy Level: Organizational

Step 4 Configure Gateway (If Required)

If your API is private or internal:

• Install On-premises Data Gateway
• Map your data source
• Assign users if needed

Step 5 Test Data Refresh

• Run a manual refresh to confirm everything is working correctly

Desktop vs Service Permissions

Common Issues and Fixes

• Refresh Failed Error → Recheck credentials in Service
• Unauthorized API Access → Verify authentication method
• Privacy Level Conflict → Align Desktop and Service settings
• Gateway Not Working → Check connection and permissions

Final Notes

So today we learned how to manage data source permissions for APIs in Power BI Desktop and Power BI Service. This is a small setup, but it plays a big role in ensuring smooth data refresh and reliable reporting.

Always remember, configuring permissions in Desktop is not enough. You must also update them in the Service after publishing.

Practice this setup in your environment to avoid common API errors and improve report performance.

See you next time with another Power BI topic