cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Already connected to Azure Consumption Insights and can see data including financials va Power BI Service.

 

When trying to connect with Power BI Desktop, the schema shows then an error message is displayed PBDConsumptionError.PNG

Using API key value in Account key, still getting access to resource is forbidden.

 

Any ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Hi Vicky,

 

Tried steps 1 to 3 before posting the issue.

 

Tried via Excel and captured the issue.

 

ForcePoint (Our on-premises Firewall solution) was blocking https://consumption.azure.com

 

This has now been fixed and can use the data source as defined in the article.

 

Any questions just ask.

Thanks,

John

 

 

 

 

6 REPLIES 6
Moderator v-qiuyu-msft
Moderator

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Hi @JohnAtAggreko,

 

1. Please go to Data source Settings, find it the data source exist in the current file or global, if it does, please clear it's permission by click "Clear Permissions". 

 

q3.PNG

 

2. Please follow this article to get data in Power BI desktop from Azure Consumption Insights. Verify the access key you provided is valid, you find it from Azure EnterPrise portal like below: 

 

azure-consumption-insights_09.png

 

3. Please try to update the Power BI desktop to the latest version. 

 

4. If issue persists, please enable desktop trace log, repeat the steps to reproduce the issue and share the trace log files with us. 

 

Best Regards,
Qiuyun Yu 

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vicky_Song Established Member
Established Member

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden - Status changed to: Needs Info

 

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Hi Vicky,

 

Tried steps 1 to 3 before posting the issue.

 

Tried via Excel and captured the issue.

 

ForcePoint (Our on-premises Firewall solution) was blocking https://consumption.azure.com

 

This has now been fixed and can use the data source as defined in the article.

 

Any questions just ask.

Thanks,

John

 

 

 

 

Moderator v-qiuyu-msft
Moderator

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Hi @JohnAtAggreko,

 

From your description, it seems that the issue is solved now and you can get data from Azure Consumption Insights in Power BI desktop fine, right? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Yes my issue is now resolved.

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Powewr BI Desktop AzureConsumptionInsights Access to Resource is forbidden

Hi @JohnAtAggreko,

 

Thanks for your update. Smiley Happy

 

As the issue is solved now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.