Forum Discussion
Solved
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 o...
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.
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