Forum Discussion
Reporting from Excel file system using Excel Online in Power BI Service
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.
Hi Miguel Félix,
Thanks a lot for the reponse.
I will try doing it.
Changing the parameter on the service should help.
2 Quick questions on that
1. Once I have the full data by changing the parameter on the service, how can I do the validation on the full data in Power Query?
2. Does loading the full data by changing the parameter on service require a gateway to be set up? I think it does.
Super UserYou 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.