Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data Flow Error - DISP_E_TYPEMISMATCH

Hi all, 

I developed a couple of data flows (DF) and now I'm trying to connect existent dashboards to this DF. This DT would substitute existing tables in the reports that have too many transformations and so take too much time to update.

So, what I basically did was, from Power Query, copied the full code from the advance editor and in the DF query open a new query and paste the complete code. After that each table is now a table into the DF.

I did this with 3 tables and so far 2 work perfectly, the data came in with all the transformations and I was able to, on the original reports, substitute the tables for the new DF source. Everything fine except that there is a single table that keeps showing me an error every time I tried to replace it for the DT as a new source.

 

Since the DF would be feeding 2 different reports I tried the process on both and it returned the same error with more or less the same information.

 

 

 I tried to investigate the error and possible ways to fix it, and went and check the specified column and inconsistencies on the Types, but everything seems to match. Also, the weird thing (at least for me) is that the table and the DF have the exact same code, and it works as table but gives the error when the source is the DF.

Any ideas where do I can spot my error/s???

Thanks in advance.