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 PowerBI.com I can't select the enterprise Gateway. The problem looks in the direction of the Excel file
I read a lot of articles about this case is but i can't find the solution. What do ik overlook?
Greetings, Norbertus
3 Replies
Can you move your Excel file to on-premises? That might fix your issue.
File 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.
