Monday.com to Power BI
Hello, I work for a Hyundai dealer in the UK.
We are currently trying to create a digital Sales leaderboard that feeds from our Monday.com account to Power BI. We have a form on Monday that takes which site has sold a car and a load of other questions. We are struggling to send this data to Power BI. I have tried to send it through Power Flow but it shows that there is no dataset when using the ‘add rows to dataset’. I am just a Marketing exec with no experience in any of this.
https://preview.redd.it/lqx00f9wf6ce1.png?width=1162&format=png&auto=webp&s=060868a965f19b01e5a5002b785955461898628a
^ This is how we would like it to look (mocked up in Excel) on page 1.
https://preview.redd.it/9tscft65g6ce1.png?width=1104&format=png&auto=webp&s=53406e4afce836d875f0e36bf8af1ba7ba3cfdf0
^ This is the weekly sales list which should refresh weekly (mocked up on excel again)
https://preview.redd.it/0i26xctfg6ce1.png?width=1128&format=png&auto=webp&s=4c8362e8d8df9f4172fbfb971344f7c8c63b15eb
^ and Finally this page which should display all the car deliveries that are going out on that month.
I understand this is a big ask but if anybody could assist me with a way to do this it would be greatly appreciated as I’m tearing my hair out trying to figure out how to do this
The short answer is:
The Power Automate ‘add rows to dataset’ action is likely failing because you need to first explicitly create a special Power BI “Push Dataset” using the Power BI REST API, which acts as a table that Power Automate can send data to.
Since your goal is a live leaderboard, you should actually bypass Power Automate for this real-time data flow and instead use a monday.com Platform API webhook to send data directly to an external, cheap hosting service.
This service can run a simple, small script that hits the Power BI REST API endpoint every time a sale is made.
This process creates a low-latency, scalable, and near real-time leaderboard solution without complex Power Automate limits or the need for a premium connector.
The long answer is:
The reason the native Power Automate connector is giving you trouble is twofold.
First, the “Add rows to dataset” action typically requires a Power BI Push Dataset to already be configured in the Power BI Service, and this dataset must perfectly match the column names and data types of the information coming from monday.com.
Power Automate is not great at automatically creating or managing these for complex data structures.
Second, while Power Automate is part of the Microsoft stack, its performance and cost for real-time reporting are often less efficient than a custom solution for high-volume data pushes.
The most efficient and most modern way to build a real-time leaderboard from any source to Power BI is to use Power BI’s built-in Push Dataset functionality, which is designed for this exact scenario.
This is what we will target.
Instead of Power Automate, you can use a combination of a monday.com Platform API webhook and a cheap server environment like Google Tag Manager Server Container, or a managed server platform like Stape or even a simple Google Cloud Platform (GCP) or Azure Function.
Here is the process: first, create a Push Dataset in the Power BI Service with the exact schema you need (Site, Salesperson, Car Sold, Date, etc.).
This dataset will have a unique API endpoint.
Second, in monday.com, set up an Automation using the “When an item is created, send a webhook” recipe.
This is the monday.com Platform API webhook.
The webhook’s URL will point to a custom server environment like a GTM Server Container, Stape, or GCP.
This server acts as the “bridge.”
The bridge’s only job is to receive the JSON data sent by monday.com when a new sale is logged, transform it into the simple JSON format that the Power BI REST API expects, and send it to the unique Power BI Push Dataset URL.
This setup is highly effective because you are only sending a tiny payload (one new sale) immediately after it happens, resulting in a near real-time update on your dashboard.
This approach is often free or extremely low-cost with platforms like GTM Server or Stape since they are designed to handle high volumes of small API calls efficiently, and it completely bypasses the complexity and sometimes higher costs associated with licensing the premium features in Power Automate needed for complex data flows.
Once the data is in your Power BI Push Dataset, you can create your visualizations like the leaderboards and delivery lists, and they will update within seconds of a new car sale being logged in monday.com.
About The Author
