What’s an On-premise Data Gateway? When to use it? On-premise Data Gateway as the name suggest it’s a Gateway or hub to connect on-premise data sources to Microsoft cloud services like Power BI, Power Apps, etc. You will need to use the Gateway if you are dealing with an on-premise data sources. Cloud data-sources usually […]
Everything you need to know about the On-premise Data Gateway Read More »
In this blog post I will be implementing a simple web scraping using Power Automate Desktop (RPA) tool. There are some use cases when you will need to scrape or extract data from the website for analytics purposes. For this post, say you have a requirement to know whether the US stock market is overvalued
Web Scraping using Power Automate Desktop – S&P 500 P/E ratio Read More »
In most cases you will want to have scheduled or event-based refresh, but there are some cases where you will want end-users to refresh the Power BI dataset. The main objective of Power Platform is to democratize the data so with Power Automate visuals integration into Power BI makes this becomes possible by giving power
Last year I was working on a requirement, to implement event-based dataset refresh that can send out an email when the refresh has completed successfully or failed. I came across Power Automate as the tool of choice to achieve this task easily and efficiently. Power Automate becoming main stream into Power BI visual does speak
Event-based Power BI dataset refresh with email notification Read More »
