Forum Discussion

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper 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
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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.