Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Automated refresh excel from network path data in power BI
I have reading excel from network path. If i change excel data, BU report should refresh. How can i achieve this in Power BI. Do we have extract refresh?
I am new to power BI
Solved! Go to Solution.
@Anonymous
1) your excel sheet is in the Network folder just copy that path or connect in Power BI desktop.
2) With SQL no need to do anything it will auto fetch your login credentials
3) Publish your report to power bi service and schedule refresh time
@Anonymous
connect to network path excel sheet and schedule a refresh time in Power BI service.
regards,
Aditya
Do you have any reference link for this i am new to PowerBI
Dear @Anonymous
You can refresh the data in 2 ways
Power BI desktop: Whenever excel is updated with the data then refresh the report/dashboard and publish in the Service/Cloud
Power BI Service: you can schedule the auto refresh by creating the gateway with the network path then the updated data will be displayed in the dashboard.
You can find the details in the following path
https://docs.microsoft.com/en-us/power-bi/refresh-data
Regards,
Munna
how do i create gateway with the network path?
I have use network path in POWER BI desktop
fyi -my report contains 2 sub reports - one with sql source and other excel from network path
@Anonymous
1) your excel sheet is in the Network folder just copy that path or connect in Power BI desktop.
2) With SQL no need to do anything it will auto fetch your login credentials
3) Publish your report to power bi service and schedule refresh time
thanks for sharing the Link
I tried to upload my excel worksheet in PowerBI service. But how do i consume that worksheet in powerbi desktop
Dear @Anonymous
In Power BI Desktop it is not the auto-refresh, you have to refresh manually.
Regards,
Munna
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |