Forum Discussion
Solved
Reporting from Excel file system using Excel Online in Power BI Service
We do not have a data warehouse at present and I am trying to report on Excel files stored on premise in a shared drive. The total size of all the files would be nearly 40 GB. I am wondering if ...
You will always need to setup the gateway since you have on prem files.
The parameter is to land on a different folder thart has less data and then when you connect on the service you change the folder to the actual one.
MFelix
Super User
Super UserHi poweredsoul ,
You can use the gateway to access directly the files on the Dataflows (Power Query online) you just need to select the correct connection when creating the dataflow:
You can also do the transformation on the desktop and then when you do the publish to the web you connect to the gateway and the transformations will be assume on-prem