Forum Discussion

ronrsnfld's avatar
ronrsnfld
Super User
1 year ago
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 (...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
1 year ago

Thank you for that.

I will go through it and circle back if I still have questions.

ronrsnfld's avatar
ronrsnfld
Super User
1 year ago

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.

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    These tools use different implementations of the Power Query engine. Power BI has much tighter restrictions around cross partition data bleed etc.