Reply
Luukv93
Frequent Visitor
Partially syndicated - Outbound

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?

 

 

 

 

tempsnip.pngtempsnip.png

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicated - Outbound

Hi @v-yuezhe-msft, is a data source required for each excel file connected to my reports?

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Yes you need a connection for each Excel file

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Connections are impossible although on-premises gateway says it is ready for connections.

 

Why are there no answers to this question?

 

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)