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

Refreshing Excel data sources with gateway cluster

I have successfully setup my cloud gateway to refresh a dataset linked to an on-prem excel spreadsheet. This was done by manually adding the file path of the network share to the gateway, \\servername\some-folder\Book1.xlsx The issue is now that every time we want to create a new report/dataset we have to manually add the file to the gateway, this doesn't seem practical for all users. Is there a way to just link a whole folder \\servername\some-folder and be able to refresh any of the contents within this? Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
rainer1 Member
Member

Re: Refreshing Excel data sources with gateway cluster

Hi dcullen,

 

your question is a bit confusing.

 

A excel sheet is handled by power bi like any database. So, for every new excel sheet you have to add this to the gateway.

 

If you want to refresh the data in the excel file you should overwrite the excisting Excel File with the same name.

 

If you want to build a new Report based on the same data you can connect your new Report in Power BI Desktop to the excisting Dataset who is already connected to the local file.

 

I hope this answered your question if not let me know.

View solution in original post

2 REPLIES 2
rainer1 Member
Member

Re: Refreshing Excel data sources with gateway cluster

Hi dcullen,

 

your question is a bit confusing.

 

A excel sheet is handled by power bi like any database. So, for every new excel sheet you have to add this to the gateway.

 

If you want to refresh the data in the excel file you should overwrite the excisting Excel File with the same name.

 

If you want to build a new Report based on the same data you can connect your new Report in Power BI Desktop to the excisting Dataset who is already connected to the local file.

 

I hope this answered your question if not let me know.

View solution in original post

dcullen Frequent Visitor
Frequent Visitor

Re: Refreshing Excel data sources with gateway cluster

Thank you, yes this did answer my question. I'm unable to 'accept as an answer' as internal firewall is blocking some javascripts.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors