Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error to Connect the report #693

Open
paragbhardwaj1981 opened this issue Apr 22, 2024 · 12 comments
Open

Error to Connect the report #693

paragbhardwaj1981 opened this issue Apr 22, 2024 · 12 comments
Assignees
Labels
Area: Power BI Power BI reports Needs: Attention 👋 Issue or PR needs to be reviewed by the author or it will be closed due to no activity Needs: Triage 🔍 Untriaged issue needs to be reviewed

Comments

@paragbhardwaj1981
Copy link

paragbhardwaj1981 commented Apr 22, 2024

🐛 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:

  1. Go to
  2. Click on
  3. Scroll down to
  4. 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.

image

📷 Screenshots

image

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.
@paragbhardwaj1981 paragbhardwaj1981 added Needs: Triage 🔍 Untriaged issue needs to be reviewed Type: Bug 🐛 Something isn't working labels Apr 22, 2024
@paragbhardwaj1981
Copy link
Author

Please Provide your solution

@paragbhardwaj1981
Copy link
Author

Hi Team,

Can you please provide the feedback to me.

Thanks
Parag

@devisaladi
Copy link

@flanakin AnyUpdate . Appreciate if we have soltuion

@radut227
Copy link

radut227 commented May 3, 2024

Dear Team
Facing the same issue with Cost Detail "Access to the resource is forbidden".

Any pointers?
Regards
Rahul

@arthurclares
Copy link
Contributor

@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.

@flanakin
Copy link
Contributor

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 flanakin added Needs: Attention 👋 Issue or PR needs to be reviewed by the author or it will be closed due to no activity Solution: FinOps hubs Data pipeline solution Area: Power BI Power BI reports and removed Solution: FinOps hubs Data pipeline solution labels May 14, 2024
@devisaladi
Copy link

devisaladi commented May 14, 2024

@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

image

Thanks
Devi

@arthurclares
Copy link
Contributor

@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?

@devisaladi
Copy link

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

image

@paragbhardwaj1981
Copy link
Author

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.
image

@flanakin
Copy link
Contributor

flanakin commented May 25, 2024

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.

@flanakin
Copy link
Contributor

@paragbhardwaj1981 Try this:

  1. Confirm that CSV files are getting exported into the msexports container. If not, update the Cost Management export configuration.
  2. 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.
  3. 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.
  4. Re-run Cost Management exports. You can also run exports for previous months either from the portal or using the Start-FinOpsCostExports command.

@flanakin flanakin removed their assignment May 25, 2024
@flanakin flanakin removed the Type: Bug 🐛 Something isn't working label May 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Area: Power BI Power BI reports Needs: Attention 👋 Issue or PR needs to be reviewed by the author or it will be closed due to no activity Needs: Triage 🔍 Untriaged issue needs to be reviewed
Projects
None yet
Development

No branches or pull requests

5 participants