Summary
Customers may get their PBI Desktop and PBI Service upgraded to the 2025 May release and find that reports are failing with error Cannot convert the value null to type Record.
Reported Issue
Relevant Versions
All Dremio releases / Microsoft Power BI May release (2.143.878.0)
Steps to Resolve
Please update the report’s connection signature to explicitly pass an empty array as the final parameter. For example, change:
Dremio.DatabasesV370(servername, encryption, engine, routingTag, routingQueue, null)
Dremio.DatabasesV370(servername, encryption, engine, routingTag, routingQueue, [])
A future release will allow the passing of null in the final parameter, restoring compatibility with older report definitions.
NOTE:
The workaround above is applicable to the Dremio Software connector only. If you are using the Dremio cloud connector, a viable workaround would be to introduce a Microsoft PowerBI Gateway, where you would be able to choose an earlier connector until such time as a the issue is fixed.
Also documented here: https://docs.dremio.com/current/client-applications/microsoft-power-bi/working-from-datasets/administrators/troubleshooting-connectivity/#power-bi-update-may-2025