Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-lili6-msft
Community Support
Community Support

HI, @Anonymous 

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-to-use-it

 

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.
Anonymous
Not applicable

Thank you 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors