Tutorial: Trigger dataset refresh for SharePoint lists or OneDrive Excel files with Flow and Power BI Or, head on over to Flow to try it out for yourself. Whether your trigger is based on changes to items in your SharePoint list or updates to an Excel file in OneDrive or SharePoint Online or a complex day and time schedule, there are dozens of use cases for this action.Įxcited? Read on for a full tutorial of using the new refresh a dataset action to automate refreshing a Power BI report based on changes to a SharePoint list. ![]() Now, you will be able to trigger dataset refreshes based on hundreds of Flow triggers. Specifically, we have added a new Refresh a dataset action to the Power BI connector for Microsoft Flow. Today, we are making scheduling of refreshes much more flexible to improve how Power BI works in processes like the ones described above. Power BI’s existing fixed refresh schedules are not sufficient to accomplish this and manually refreshing the Power BI dataset each time your access a report adds extra steps and creates confusion. ![]() With these sorts of processes, users often expect Power BI reports to be updated as soon as they enter data in underlying systems. ![]() Business processes like managing a team’s budget requests, planning hiring activities, and evaluating marketing campaigns can all fit this pattern. ![]() When speaking with customers about how they’ve used Power BI to improve collaborative business processes in their organization, we often hear that Power BI is used to summarize and visualize data that many end users are entering into tools like Excel files, SharePoint lists, or the Common Data Service.
0 Comments
Leave a Reply. |