Forum Discussion

Mo_'s avatar
Mo_
Advocate I
1 year ago
Solved

Bug? Can't refresh data in Power BI Desktop

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: ...
Need Help
  • Mo_'s avatar
    Mo_
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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_'s avatar
Mo_
Advocate I
1 year ago

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