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.
lbendlin I went through that excellent reference. (Just the one chapter. I have read some of the others).
What I don't understand, though, is why it does work in Power Query (whether accessed via Power BI or Excel) and it can be Loaded in Excel to a worksheet but cannot be Applied in Power BI.
These tools use different implementations of the Power Query engine. Power BI has much tighter restrictions around cross partition data bleed etc.