Error to Connect the report
🐛 Problem
When i put my EA Number and not able to fetch the data. It is Saying Cost Detail "Access to the resource is forbidden". I have follow all the instruction and having the same issue. I have full rights on my Azure Cloud.
👣 Repro steps
TODO: Add repro steps below:
- Go to
- Click on
- Scroll down to
- See error
🤔 Expected
I am expecting that i will be able to connect my Cost through finops toolkit. I have already setup all the infrastucture.
📷 Screenshots
🙋♀️ Ask for the community
We could use your help:
- Please vote this issue up (👍) to prioritize it.
- Leave comments to help us solidify the vision.
Please Provide your solution
Hi Team,
Can you please provide the feedback to me.
Thanks Parag
@flanakin AnyUpdate . Appreciate if we have soltuion
Dear Team Facing the same issue with Cost Detail "Access to the resource is forbidden".
Any pointers? Regards Rahul
@paragbhardwaj1981 Can you please make sure the account used in the login has the role "Storage Blob Data Reader role" assigned? This role needs to be explicit assigned.
FYI - Arthur and I just ran thru this with @radut227 and the issue was that the Storage Blob Data Reader role wasn't assigned to the user who was loading data in Power BI. Please note you need at least one "Storage Blob Data" role even if you're a Reader, Contributor, or Owner on the storage account.
We do cover this in the docs, but we'll update it to be more explicit.
@devisaladi, can you also confirm if this helps you?
@flanakin we added storage blob data reader role for my account still issue persist . can we have some one who can help us to setup this aptly so that we can save time . we have been working on it for a month . Got stuck , also we created Microsoft ticket for help at the earliest . can you please guide us who can help us in saving time in setting this up .please refer to the below screenshot for specific error
Thanks Devi
@devisaladi This error message normally indicates that the storage account is empty. Can you go to the storage account and see if the msexport container has a .parquet file?
If not, double check your cost exports are running fine and check if the data explorer pipelines are also working.
Can you also confirm that adding the storage blob reader permissions to your storage fixed the "Access to resource is forbidden" issue?
Can you also confirm that adding the storage blob reader permissions to your storage fixed the "Access to resource is forbidden" issue?
Yes the issue is gone after having storage blob reader role .
. Can you go to the storage account and see if the msexport container has a .parquet file? please find the attached screenshot that has storage account is not empty
I believe we are missing the file .parquet. We have follow below steps and in Storage account we are seeing only .csv file. Any idea how to genrate .parquet file.
FYI - We spoke to @devisaladi and the primary issue there was the export was going to the ingestion container. Exports should be configured to go to the msexports container. They were also running the 0.2 release, which has a known bug. They're updating to 0.3 to confirm everything is working as expected now.
@paragbhardwaj1981 Try this:
- Confirm that CSV files are getting exported into the
msexportscontainer. If not, update the Cost Management export configuration. - Confirm that the Microsoft.EventGrid resource provider is enabled on the subscription by going to Subscriptions > (your sub) > Settings > Resource providers and confirming Microsoft.EventGrid is set to "Registered". If not, register it from that screen.
- Confirm the Data Factory trigger is started by going to Resource groups > (your hub RG) > (your Data Factory resource) > Launch Studio > Manage (toolbox icon) > Triggers and confirming all triggers are started. If not, click the Play icon for the trigger(s) and then click the "Publish all" button at the top. Confirm that finishes publishing successfully.
- Re-run Cost Management exports. You can also run exports for previous months either from the portal or using the Start-FinOpsCostExports command.
@paragbhardwaj1981 any updates? Were you able to get past this? If not, we should setup a call to get you unblocked.
Closing this as we already had a call with the customer.