Skip to content

FinOps Toolkit 0.9 Governance Power BI - If you have sql databases it gives an error on report refresh #1550

Description

@NicholasBrand

🐛 Problem

If the resource graph query in SqlDatabases returns no records the following applied step will return an error preventing report refresh:
= Table.TransformColumnTypes(Source, {{"properties.creationDate", type datetimezone}})

This is the error you get:

Expression.Error: The column 'properties.creationDate' of the table wasn't found.
Details:
    properties.creationDate

👣 Repro steps

  1. Refresh report where there are no sql databases
  2. the above error will occur

🤔 Expected

Report should refresh successfully even if there are no SQL databases.

Metadata

Metadata

Assignees

Labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions