Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 failed or what I did wrong?
Solved! Go to Solution.
@Luukv93,
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-o...
Regards,
Lydia
@Luukv93,
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-o...
Regards,
Lydia
Hi @v-yuezhe-msft, is a data source required for each excel file connected to my reports?
Yes you need a connection for each Excel file
Connections are impossible although on-premises gateway says it is ready for connections.
Why are there no answers to this question?
Who should connect a gateway manager or the gateway serviceaccount?
connection in Power BI desktop work fine.
there are no connections possible no local xlsx files, no database (Postgres), an nog online data from a service-provicer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.