Error encountered

[Revilo]

When I tried to refresh my PowerBI report I received the below error message.

Load was cancelled by an error in loading a previous table.

OLE DB or ODBC error: [Expression.Error] We cannot convert the value null to type Text..

Pls. help

[Idrissshatila · Accepted solution]

Hello @Revilo ,

To check what's the error, go to power query (Trasnform Data tab), and try clicking on each table to see where is the error comes from, and they will point you out to the table that has the error as well as which step is making the error.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[bhelou]

Hi , did you check power queries , try to change the format of the columns that have null values and replace null to 0 maybe this will solve the issue