Power BI Update (May 2025)

Power BI Connector for Dremio Software

Problem with Power BI Connector for Dremio Cloud

Starting in May 2025, Power BI semantic models using the Dremio.DatabasesV370 function with a null value as the final argument began to fail with the following errors:

Unable to connect to the data source.

Cannot convert the value null to type Record.

Solution

For Power BI Desktop

If the report was originally created without last options parameter or with last options parameter set to null, explicitly modify the query’s connection signature to include an empty record/map as the final parameter:

Dremio.DatabasesV370(servername, encryption, engine, routingTag, routingQueue, [])

This ensures that parameter handling aligns with expected behavior in Power BI Desktop.

Resolution Timeline

The issue is planned to be fixed in the coming weeks. Once the fix is released, passing null as the final parameter will no longer result in a failure, restoring compatibility with older report definitions.