- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 failed or what I did wrong?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @v-yuezhe-msft, is a data source required for each excel file connected to my reports?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes you need a connection for each Excel file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Connections are impossible although on-premises gateway says it is ready for connections.
Why are there no answers to this question?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-19-2024 09:36 AM | |||
02-13-2024 06:53 AM | |||
09-23-2024 02:51 PM | |||
05-01-2024 10:44 PM | |||
03-15-2024 02:37 PM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
8 |