Forum Discussion
Error encountered
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
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 👍
2 Replies
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 👍
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
