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

Not able to add scheduled refresh for on-premise gateway with multiple source files

I'm unable to schedule a refresh using the on-premise Gateway.  It appears that the issue is multiple file sources in my pbix.  

 

I'm attempting to use 4 Excel files within one pbix.  I have each source file set up under Data Source Settings.  It says the connections were successful.  But when I go to the Power BI Service, select the Dataset, and go to Gateway Connection, the Use Data Gateway option is grayed out.

 

I've already double checked that the file path is the same for both the Data Source Settings and within the Query Editor.

 

When I remove all the source files but one, then I am able to select the Gateway Connection. This makes me think the issue is related to having more than one Excel file as a source.   

 

I'm not able to consolidate to one Excel file, so I really need to figure out a solution here.  Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Not able to add scheduled refresh for on-premise gateway with multiple source files

Hi @jmcosi,

Your resource data come from 4 Excel files which are located your local computer, right? If it is, you should create four resource dara in gateway. I try to reproduce your scenario and get expected result.

In my PowerBI desktop, I use two excel file in my local computer. After save, I publish it to Power Bi service. Create two date source, for the following screenshot, New data source1 add one excel, and New data source2 add another excel. 

2.PNG

3.png

In Power BI service, select the Dataset, and go to Gateway Connection, it works fine as follows.

1.PNG

Please check your operation and check if you create data source successfully.

Best Regards,
Angelia

View solution in original post

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: Not able to add scheduled refresh for on-premise gateway with multiple source files

Hi @jmcosi,

Your resource data come from 4 Excel files which are located your local computer, right? If it is, you should create four resource dara in gateway. I try to reproduce your scenario and get expected result.

In my PowerBI desktop, I use two excel file in my local computer. After save, I publish it to Power Bi service. Create two date source, for the following screenshot, New data source1 add one excel, and New data source2 add another excel. 

2.PNG

3.png

In Power BI service, select the Dataset, and go to Gateway Connection, it works fine as follows.

1.PNG

Please check your operation and check if you create data source successfully.

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 290 members 2,770 guests
Please welcome our newest community members: