Connect Power BI to Excel File-Series 3 of 4
Power BI can connect to many data sources including Excel. In the previous parts of this 4 part series, we setup the automation to populate an Excel master data file in SharePoint. Next part is to connect the Power BI service to the master Excel file. The Power BI Service is the online portion of […]
Manage Power BI Data Refresh-Series 4 of 4
Now that the Excel file is connected to the Power BI Service, it should be automatically be setup to refresh the report data every hour but to confirm or make changes review the steps below: Step 1: Select “Data hub” on the left side bar and then settings on the 3 ellipses next to the […]
