ERROR HRESULT: 0x80040E4E when changing SQL QUERY TYPE COLUMNS

[brunozanoelo]

I´ve changed all my PK columns from STRING to INTEGER, why? BETTER PERFORMANCE.

Example:
from 
PK1 || "_" || PK2 AS INTEGER) as column1
to
CAST(PK1 || PK2 AS INTEGER) as column1

PowerBI understand that the type has changed but even thought I´m receiving this crazy error.

[brunozanoelo · Accepted solution]

I´ve solved this error doing the following steps:
1) Changed to an empty database (just the same structure);
2) Cleaned all the cache in menu Options;
3) Restarted PowerBI Desktop;
4) Refreshed;

[V-lianl-msft]

Hi @brunozanoelo ,

Based on your description, this error occurs after applying the SQL query, which may be due to the data processing steps added to the query editor before. Save a copy pbix and delete all operations after connecting to the data source to see if there are errors.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@brunozanoelo , open edit query mode, you should see some more details . Share that

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s