Realtime Power BI report with sharepoint data using power automate

Often we have a requirement to create a real-time power report for SharePoint data. but, when we connect to SharePoint list data from Power BI, the only option we have is to use import query mode instead of the direct query. This method only allows the data refresh up 8 times per day with Power […]

Read More

Merge Multiple SharePoint Lists to one Excel file Dynamically

The Need There is not an easy and direct method to export data from multiple SharePoint lists and consolidate it in a single Excel file. The Solution To merge multiple SharePoint lists in single excel, we will use followings Power Automate actions: Excel Actions SharePoint Actions I have the create two sample SharePoint lists to […]

Read More