You have a Microsoft Excel file on a file server.
You create a Power BI report and import a table from the Excel file.
You publish the report.
You need to ensure that the data refreshes every four hours.
What should you do first?

A. Upload the Excel file to a Power BI workspace.

B. Create a subscription to the report.

C. Deploy an on-premises data gateway.

D. Edit the data source credentials.








 

Suggested Answer: C

You can scheduled refresh for the On-premises data gateway (personal mode) and the On-premises data gateway. You specify refresh options in the following areas of the Power BI service: Gateway connection, Data source credentials, and Scheduled refresh.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate