cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sherrybay
Regular Visitor

Enterprise Gateway: SQL server and Excel data sources used at the same time

Does the enterprise gateway support using SQL server and Excel data sources in the same Power BI file at the same time? If not, is there an update coming soon that will support this? Right now, the only way I can get refresh my reports is through a manual process using Power BI desktop and republishing. Our data is quite dynamic, so this workaround is not ideal. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I've got network drives set up for this.  I have a service account in AD which i give access to this folder.  If I do a remote connection to my server that is hosting the gateway, I should be able to access this folder.

 

Next, when you use this file in your project, you just need to make sure you are connecting to it using its Network address, instead of any mapped drives.  I.e. (//Server/Folder/File.xlsx  instead of P:\Folder\File.xlsx)

 

There might be other options too.

 

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Microsoft
Microsoft

@sherrybay,

Alternatively, you can store Excel file on OneDrive for Business or SharePoint Online, then use on-premise gateway(personal mode) to refresh your dataset in Power BI Service.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I use an on-premise data gateway with both SQL and Excel files.  Where you store the files will be important.  As long as the gateway has access to all SQL and Excel sources, you will be fine.

That is great news. Our enterprise gateway (is that the same as an on-premise gateway?) definitely works with our SQL server database-based reports. The addition of the Excel file is the problem. Where do I need to store the Excel file? Thanks for any advice you can provide. 

Anonymous
Not applicable

I've got network drives set up for this.  I have a service account in AD which i give access to this folder.  If I do a remote connection to my server that is hosting the gateway, I should be able to access this folder.

 

Next, when you use this file in your project, you just need to make sure you are connecting to it using its Network address, instead of any mapped drives.  I.e. (//Server/Folder/File.xlsx  instead of P:\Folder\File.xlsx)

 

There might be other options too.

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors