0

We are in the process of replacing an On-Premises Data Gateway running on a VM with a Virtual Network Data Gateway running in Azure; the VNet Data Gateway has full connectivity and name resolution to the on-premises environment.

There are several PowerBI reports which make use of the data gateway to access on-premises data sources, and for most of them the conversion is quite straightforward; however, one of them uses an Excel file on a local file server as a data source.

According to the documentation, Excel is a supported data source when the VNet Data Gateway is connected to your on-premises network using a VPN or ExpressRoute (which is our case); however, it just doesn't appear in the available data sources list when trying to create a connection; nor does it appear anything like "file", "folder", "file share", or such. It is possible to connect to a file on an Azure File Share, but this explicitly requires an Azure File Share URL and doesn't support SMB syntax.

Is the documentation wrong?

If not, how can a PowerBI report use an on-premises Excel file as a data source through a Virtual Network Data Gateway?

Improve this question
4
  • To whoever voted to close: if this question is deemed to be off-topic here, I'll try asking it on ServerFault; but there are lots of questions about PowerBI and DataGateways here, as confirmed by even being tags for them; on ServerFault, there is none. This is why I asked here in the first place. Commented Sep 3 at 21:43
  • And I think you are right asking here. Commented Sep 4 at 13:44
  • Why don't you put the Excel on Sharepoint? And use Sharepoint as a connector? Commented Sep 4 at 13:45
  • Unfortunately the file has to stay on the file server; anyway, I'm more interested in why something that is supposed to be possible according to the documentation can't actually be done... Commented Sep 4 at 15:55
Related questions
8
Azure - Virtual network Gateway vs VPN gateways
0
How to connect to Microsoft cloud services using ExpressRoute from home network?
0
Azure OpenVPN appliance not traversing virtual network gateway
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.