You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A . Configure the dataset to use the existing On-premises data gateway.
B . Deploy an On-premises data gateway in personal mode.
C . Set the refresh frequency to Daily.
D . Configure the dataset to use the personal gateway.
Answer: A ,C
Explanation:
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn’t in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you’re the only person who creates reports, and you don’t need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Leave a Reply