Forum Discussion
Power Bi Problems with Schedule Refresh
Hi Anonymous ,
Yes, you will need a Gateway setup and the path to your Excel file added as a Data Source. See this article for using a Gateway:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn
And, along with the links Isent above, this is another helpful article:Add or remove a gateway data source - Power BI | Microsoft Learn
Hi Anonymous ,
The service needs to have a gateway and this file as a data source for it to be able to access the file on your machine. If it is set up as a data source in the gateway already then you can select the "Data Credentials" in the settings for the semantic model and modify it there. You will see something like this if it is wrong at this step:
There are numerous web articles about using Excel, but here is one to help you get started:
Get data from Excel workbook files - Power BI | Microsoft Learn
My data source credentials are grayed out and unselectable.
Hi Anonymous ,
Yes, you will need a Gateway setup and the path to your Excel file added as a Data Source. See this article for using a Gateway:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn
And, along with the links Isent above, this is another helpful article:Add or remove a gateway data source - Power BI | Microsoft Learn