Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

OLE DB or ODBC error: [Expression.error]

Hi everyone,   I have a PowerBI report that I built using Excel PowerQuery and loaded it all into the data model then into PowerBI. The source files and the PowerQuery file I'm using for the data m...
Need Help
  • Aron_Moore's avatar
    Aron_Moore
    8 years ago

    When you created the .PBIX did you pull from the excel stored in sharepoint or did you pull from excel stored local then uploaded that excel to sharepoint?

     

    I suspect the latter which will give you errors without a personal gateway, system powered on and online, etc.

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

How about installing the 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider on your server?

 

Best Regards

Maggie 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I have reported this error to the team, so we'll see if that's really what is needed but I really doubt it. 

    • Aron_Moore's avatar
      Aron_Moore
      Solution Specialist
      8 years ago

      When you created the .PBIX did you pull from the excel stored in sharepoint or did you pull from excel stored local then uploaded that excel to sharepoint?

       

      I suspect the latter which will give you errors without a personal gateway, system powered on and online, etc.