🐛 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

ℹ️ 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.