cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MK97
Frequent Visitor

Connection for Excel with on-premise gateway

Hello,

 

I have created a report using Power-BI Desktop. I am using two kinds of data:

- a locally stored Excel files. 

- Data from an SQL Server. 

 

And I have two servers:

-In Server A I have installed on-premises gateway

-In Server B I have all .xlsx and .pbix files.

 

I have uploaded this report (from server B) in the app.powerbi.com. Now I want this report to update automatically. For this reason, I have installed an enterprise gateway in Server A.  Through this Gateway, I can update the SQL data with no problem.

 

I  have created a test report with SQL data only.  This is working perfectly with the enterprise gateway, but my reports with SQL data and Excel file data is not updating through the enterprise gateway.

Gateway connection:

MK97_1-1643370086688.png

 

Problem: when I am trying to add Excel file to on-premise gateway I get this error:

MK97_0-1643370796171.png

 

Thank you very much for your help!

1 ACCEPTED SOLUTION
Burningsuit
Super User
Super User

Hi @MK97 

Your gateway machine (Server A) needs to have access to the Excel files on Server B. This can be through a network share or other method, but whatever way you use you should check that Server A can open the Excel files on Server B. Server A can already access the SQL database, which is why it can work, but has no access to the Excel files.

Think of a Gateway as a Power BI User sitting on Server A, it needs to have access to all the files used in the Report or it won't be able to refresh them.

An alternative option is to put the Excel files on Server A if you don't want to set up a network share in Server B for Server A's access.

Hope this helps

Stuart

View solution in original post

1 REPLY 1
Burningsuit
Super User
Super User

Hi @MK97 

Your gateway machine (Server A) needs to have access to the Excel files on Server B. This can be through a network share or other method, but whatever way you use you should check that Server A can open the Excel files on Server B. Server A can already access the SQL database, which is why it can work, but has no access to the Excel files.

Think of a Gateway as a Power BI User sitting on Server A, it needs to have access to all the files used in the Report or it won't be able to refresh them.

An alternative option is to put the Excel files on Server A if you don't want to set up a network share in Server B for Server A's access.

Hope this helps

Stuart

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors