Forum Discussion
We cannot convert the value null to type Record.
I managed to solve the problem.
The problem is in the connector with my datalake, which is Dremio.
What used to be
= Dremio.DatabasesV370(Dremio_Fonte, "Disabled", null, null, null)It changed to:
= Dremio.DatabasesV370(Dremio_Fonte, "Disabled", null, null, null, [])I made the change in the reports and it is updating normally now.
Hi rauldantas,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The “Expression.Error: We cannot convert the value null to type Record” arises when a step in Power Query expects a record but receives null, something that the Power BI Service (full, server‑side refresh with stricter connector/privacy rules) catches even if Desktop doesn’t. Pinpoint the exact failing Applied Step by stepping through the query, then add a defensive wrapper such as try <step> otherwise null or if Value.Is(x, type record) then x else null. before any record expansion or field access. Next, verify in the Service that every parameter, credential, and privacy level is correctly set (all sources usually Organizational). Common root causes include blank rows returned overnight, nested JSON fields that are sometimes null, joins whose right‐hand query failed in the Service, and prod/dev parameter mismatches. After wrapping the risky step, refresh in Desktop (clearing permissions first), republish, and trigger a Service refresh errors should disappear.
If you found this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to help others in the community.
Thank you & best regards,
Prasanna Kumar