cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
joko2008 New Member
New Member

Using Excel with Data Gateway

We are using a data gateway succesfully with numerous powerbi reports.
The same connections as defined in the data gateway are being used in Excel files, so users can
explore the on-premise tabular models in an ad-hoc fashion.
When uploading the excel files in the workbook section, the excel files open and show data.
But the filters do not work reporting connectivity problems while the connection connects to pre-defined sources in the gateway.

When starting the excel files from within desktop excel it does work. But we want to publish them via a workspace.

How can you make the data gateway connections work for your excel?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Using Excel with Data Gateway

HI, @joko2008 

If uploading the excel files in the workbook section,

When the excel is on one drive, It will keep the connection to excel 

https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files#one-excel-workbook--two-ways-...

 

Best Regards,

Lin

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

Re: Using Excel with Data Gateway

Thank you 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

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.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors