Forum Discussion
Solved
OLE DB OR ODBC error: We cannot convert the value null to type Table
This error pops up when I select Apply in Power Query in Power BI desktop.
I have a project which involves processing a number of PDF files to extract relevant information.
I have a report file (...
Please read this (ideally the entire series too) Power Query M Primer (Part 21): Identifier Scope & Sections | Ben Gribaudo
These tools use different implementations of the Power Query engine. Power BI has much tighter restrictions around cross partition data bleed etc.
I use your query and it doesn't make an error for me, can you check the queries?
I using Power BI Desktop Version: 2.136.1202.0 64-bit (September 2024).
And yes, I just copy/pasted what I posted into the Power Query Advanced Editor, and when I choose "Close and Apply", the error messages pop-up. This time they popped up for all three queries, even though I had disabled load on two of them as I noted in my instructions.