Correlation between datasets

Hi Anonymous 

In additional to amitchandak, if you want to use import mode and do not want to share your gateway with others, you can try person mode on premise gateway. If you want to use direct query , live connections or share your gateway with others, you need to install enterprise on premise gateway.

Your data source is excel, I think you will use import mode to build your report.

After you publish your report to service, you need to set schedule refresh for your report.

For more details:  Configure scheduled refresh

To keep your gateway working ,you need to keep your computer turning on. Or your schedule refresh will show failure.

If you don't want to use gateway, you can try to upload your data source on your Onedrive for Business(Cloud).

For more details : Use OneDrive for Business links in Power BI Desktop

Then build a report by data source on Onedrive for Business.

You don't need a gateway to schedule refresh this report.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.