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.
Hi, I would like to share a solution that I found. My report was showintg the same problem but my data was being imported from EXCEL tables. I solved my problem when I realized that among several tables from XLSx file I had only one table from Excel 2013. When I converted that table to XLSx the problem was solved. I hope it can help...
this was my problem. The user saved the file as '.xls' . After I updated the format to .xlsx , the error was gone.