Power BI Update (May 2025)
Problem with Power BI Connector for Dremio Cloud
Power BI Connector for Dremio Software
Starting in May 2025, Power BI semantic models using the DremioCloud.DatabasesByServerV370 function with a null value as the final argument began to fail with the following errors:
Unable to update connection credentials.
Unable to connect to the data source.
Cannot convert the value null to type Record.
Solution
Step 1: Use Power BI Gateway
To restore functionality in Power BI Service, install the April 2025 version of the Power BI Gateway.
If you already have a newer version installed, you'll need to uninstall it first, or install the older version on a separate machine or VM.
Resources:
-
Official release blog: On-premises data gateway April 2025 release
-
Download (Standard mode): Download on-premises data gateway (standard mode)
Step 2: 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:
DremioCloud.DatabasesByServerV370(servername, projectId, engine, routingTag, routingQueue, encryption, [])
This ensures that parameter handling aligns with expected behavior in Power BI Desktop.
Resolution Timeline
The issue is fixed in Power BI Service. Passing null as the final parameter will no longer result in a failure, restoring compatibility with older report definitions.