Bug? Can't refresh data in Power BI Desktop

[Mo_]

Hi,

I have a semantic model published to the service which refreshes perfectly fine. When I try to refresh the pbix-file that I used to publish the report, I get the following error message:

Interestingly this also happens when I download the semantic model, which, as mentioned, refreshes perfectly fine in the service, and then try to refresh that pbix-file in Power BI Desktop.

I use the following version: 

Version: 2.140.1078.0 64-bit (Februar 2025)

Can anyone interpret this error?

Cheers

[Anonymous]

Hi, @Mo_ 

The error message "We cannot convert the value ' ' to type Table" typically occurs when there's a mismatch in data types or an unexpected null value in your data source.

You can check the data types to ensure that all columns in the query have consistent data types. Mixing data types can cause this error.

You can also handle null values by replacing or removing null values in the data. You can use the Table.ReplaceValue function in Power Query to replace null values with default values.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mo_ · Accepted solution]

Hi @Anonymous,

the error happened in one of the steps of a query in Power Query:

I could fix the error by just removing the step. Still I wonder, why the report was refreshing just fine in the Power BI Service.

Cheers