Forum Discussion
enterprise gateway with Excel document and SQL database
Hi, My case is that I have: Report in PowerBI Desktop with data connection to: On-Premise SQL database Excel document saved in Onedrive for Business After publishing the report to PowerB...
You mean that i move the Excel file to local? Then the enterprise gatewaty doesn't work
It should be possible to conncect to an Excel File in combination with a enterprise gateway?
Greg_Deckler
Community Champion
Community ChampionFile is a supported data source type for the gateway.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
There was another thread this morning that I responded to earlier in which someone had connected 5 Excel files via the gateway but was having trouble with the 6th. I'll try to find it.