🐛 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
- Refresh report where there are no sql databases
- the above error will occur
🤔 Expected
Report should refresh successfully even if there are no SQL databases.
🐛 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:
👣 Repro steps
🤔 Expected
Report should refresh successfully even if there are no SQL databases.