Forum Discussion
Connection for excel file with on-premise gateway
Hello, I have installed the data gateway and I want to add an excel file from the q disc. Now I tried connecting to the file and got the following error code: -2147467259 Any idea what fail...
Anonymous,
Based on the above screenshot, you input wrong suffix(.xlxs) for the Excel file. The file path shoule be Drive:\XXXXX\Resultaten_2018.xlsx.
For more details about adding excel data source within gateway, please review the following similar thread.
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-on-premise-gateway/td-p/104363
Regards,
Lydia
bo_afk
Post Patron
Post PatronHi Anonymous, is a data source required for each excel file connected to my reports?
Yes you need a connection for each Excel file