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 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
Solution Specialist
Solution SpecialistWhen 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.