Forum Discussion
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...
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.
I had that same error and it ended up being because the file was password protected, so I just saved it in a different spot and under Tools -- General Options, just erase the password. Problem solved!