Forum Discussion
Login window appears each time the excel query are opened
Hi, Ivy_KK
Thanks for your detail description and reply. We may understand that you need to refresh automatically at the time of EXCEL file closure. OneDrive/SharePoint Refresh is where changes are made to Excel on OneDrive/SharePoint, then OneDrive checks Excel for changes and then updates it about every hour. You can click the link below to learn more about OneDrive Refresh.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
If we want to update the dataset when the Excel file is closed, we can try to use the Power Automate, set a trigger for SharePoint/OneDrive file changes or file closure. With this trigger, trigger a power BI refresh.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If the excel is connected with the external data source, the data will not refreshed automatially in the requsted time interval as the excel file is closed. In such case, I have already saved the excel file in Onedrive and connect source to Onedrive link, but the updates in the dataset does not refresh to the latest also.
In such case, is there a way to address the isuse.
Hi, Ivy_KK
Thanks for your detail description and reply. We may understand that you need to refresh automatically at the time of EXCEL file closure. OneDrive/SharePoint Refresh is where changes are made to Excel on OneDrive/SharePoint, then OneDrive checks Excel for changes and then updates it about every hour. You can click the link below to learn more about OneDrive Refresh.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
If we want to update the dataset when the Excel file is closed, we can try to use the Power Automate, set a trigger for SharePoint/OneDrive file changes or file closure. With this trigger, trigger a power BI refresh.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.