search

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
305 stars 106 forks source link

[Power BI] You can't schedule refresh for this semantic model #963

Closed flanakin closed 2 months ago

flanakin commented 2 months ago

🐛 Problem

FinOps toolkit 0.5 reports cannot be refreshed from the Power BI service. They show the following error:

You can't schedule refresh for this semantic model because the following data sources currently don't support refresh:

  • Data source for Query1

đŸ‘Ŗ Repro steps

  1. Download and open CostSummary.pbix
  2. Publish the report to a Power BI workspace
  3. Open the semantic model setting to set a recurring schedule
  4. See error

🤔 Expected

No error.

📷 Screenshots

Screenshot of the error

ℹī¸ Additional context

There is no "Query1", which caused some delays in discovering what the issue was.

Turns out this is caused because the call to the ADLS connector is wrapped in another call to Table.SelectRows(). The method call to pull data needs to be in its own, dedicated step.

🙋‍♀ī¸ 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.
flanakin commented 2 months ago

0.5 Power BI reports have been updated so this should be resolved. If you hit this, then please download the 0.5 reports again. You should see v24.09.06 version on the main page of the report.

The linked PR has all the fixes for this for the 0.6 release.