microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
306 stars 106 forks source link

Cost summary auto or manual refresh using Power Bi service returning an error as unsupported #1102

Open NavidKhan8 opened 2 weeks ago

NavidKhan8 commented 2 weeks ago

We are trying to setup Cost Summary PB report using the link https://microsoft.github.io/finops-toolkit/power-bi/cost-summary FinOps Hub setup completed and .parquet data export conversion completed. From Ingestion setting.json hub version is 0.6

We are able to setup cost summary report using Power Bi desktop locally and published to Power Bi workspace but in Power Bi service of workspace unable to perform refresh and getting below error:

Error: powerbi error this dataset includes a dynamic data source. Since dynamic data source arent' refreshed in the power bi service , this dataset wont be refreshed

Screenshot: Image

Kindly check and confirm.

flanakin commented 2 weeks ago

Hey, Navid. I know we had this issue with some of the other reports. I didn't realize we had it with this one as well. We're about to ship 0.7. If it's okay, I would suggest using that version of the Power BI report, which is backwards compatible with FinOps hubs 0.6. Otherwise, I can look into this after FinOps X Europe.

NavidKhan8 commented 1 week ago

[like] Navid Ulla (External) reacted to your message:


From: Michael Flanakin @.> Sent: Friday, November 8, 2024 8:57:19 AM To: microsoft/finops-toolkit @.> Cc: Navid Ulla (External) @.>; Author @.> Subject: Re: [microsoft/finops-toolkit] Cost summary auto or manual refresh using Power Bi service returning an error as unsupported (Issue #1102)

Hey, Navid. I know we had this issue with some of the other reports. I didn't realize we had it with this one as well. We're about to ship 0.7. If it's okay, I would suggest using that version of the Power BI report, which is backwards compatible with FinOps hubs 0.6. Otherwise, I can look into this after FinOps X Europe.

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/finops-toolkit/issues/1102#issuecomment-2464164500, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A3GIUEZRR3UKELXUTNROTNTZ7R4G7AVCNFSM6AAAAABRKIBY4CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRUGE3DINJQGA. You are receiving this because you authored the thread.Message ID: @.***>