The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have made a dashboard in power bi. I want to do incremental refresh in real-time i.e. if I update the data in the excel sheet it automatically updates the data on the same day within seconds or minutes.
Solved! Go to Solution.
Hi @Anonymous
This article will fill you in. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
One tip fom me, always use a SharePoint folder. Save the Excel there and import the file from there.
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Hi,
Thanks for the solution @Joe_Barry provided, and i want to offer some more information for user to refer to.
hello @Anonymous , based on your description, if you want to implement the incremental refresh, you need to put the file to a folder or sharepioint, you can refer to the following link.
And the following document is about the incremental refresh.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the solution @Joe_Barry provided, and i want to offer some more information for user to refer to.
hello @Anonymous , based on your description, if you want to implement the incremental refresh, you need to put the file to a folder or sharepioint, you can refer to the following link.
And the following document is about the incremental refresh.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
This article will fill you in. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
One tip fom me, always use a SharePoint folder. Save the Excel there and import the file from there.
Joe
Proud to be a Super User! | |
Date tables help! Learn more