Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
i am trying to schedule an excel file refresh in power bi services. Daily basis my excel file refresh in some shared path.
while doing the same, my data source settings are disabled . Can please suggest if any restriction?
Regards,
Rajendra
Solved! Go to Solution.
Hi @rajendraongole1 ,
If you want to refresh the dataset:
Make sure that your Gateway server can access this file. You will need a Read/Write permission of this path.
Configure your Power BI Desktop to connect via the same path.
Once the above is done, you should then be able to configure the Data Gateway with this new data source.
Then finally go into the dataset properties and set the Gateway to use the Gateway Server and it should then refresh.
If you want to refresh the workbook, you can refer to these documents:
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-local-drive
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Hi @rajendraongole1 ,
If you want to refresh the dataset:
Make sure that your Gateway server can access this file. You will need a Read/Write permission of this path.
Configure your Power BI Desktop to connect via the same path.
Once the above is done, you should then be able to configure the Data Gateway with this new data source.
Then finally go into the dataset properties and set the Gateway to use the Gateway Server and it should then refresh.
If you want to refresh the workbook, you can refer to these documents:
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-local-drive
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.