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

Commitment Discounts - This file is restricted #704

Open
usvjosh opened this issue May 15, 2024 · 3 comments
Open

Commitment Discounts - This file is restricted #704

usvjosh opened this issue May 15, 2024 · 3 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 Solution: FinOps hubs Data pipeline solution

Comments

@usvjosh
Copy link

usvjosh commented May 15, 2024

🐛 Problem

The CommitmentDiscounts.pbit file is giving me an error message about the file being restricted. I get this error on a company computer as well as a non-company computer. The other pbit files work just fine. I'm not sure how to work around this issue.

https://github.com/microsoft/finops-toolkit/releases/download/v0.3/CommitmentDiscounts.pbit

👣 Repro steps

  1. Download the file
  2. Open it in power bi desktop (or just open the file)
  3. error shows up

🤔 Expected

Normally it lets you configure the data sources and you can use the report.

📷 Screenshots

image

ℹ️ Additional context

🙋‍♀️ 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.
@usvjosh usvjosh added Needs: Triage 🔍 Untriaged issue needs to be reviewed Type: Bug 🐛 Something isn't working labels May 15, 2024
@arthurclares
Copy link
Contributor

@usvjosh We have uploaded a new copy of the file, can you see if that works? https://github.com/microsoft/finops-toolkit/releases/download/v0.3/CommitmentDiscounts.pbit
Also, just making sure do you want to use the .PBIT (Template) and not .PBIX file? PBIX works for most of the scenarios.

@arthurclares arthurclares added Needs: Attention 👋 Issue or PR needs to be reviewed by the author or it will be closed due to no activity Area: Power BI Power BI reports Solution: FinOps hubs Data pipeline solution and removed Needs: Triage 🔍 Untriaged issue needs to be reviewed labels May 20, 2024
@usvjosh
Copy link
Author

usvjosh commented May 21, 2024

That file opens correctly now but I'm not seeing all the data source connection options. We do want the template file because it works with the finops hub, the datalake/storage account side directly. I use the storage account key to have it load data. This lets us do scheduled refresh in power bi. If i use the windows account sign in, it won't work in power bi for scheduled refresh. The other template files work just fine, just this one is wonky. Thank you for the help so far.

image

image

image

@flanakin
Copy link
Contributor

@usvjosh The second screenshot is for the Cost Management connector, which only supports a user account or service principal. This one isn't the storage account, so you won't be able to use a storage account token.

@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 Solution: FinOps hubs Data pipeline solution
Projects
None yet
Development

No branches or pull requests

3 participants