Unanswered

Refreshing Power BI dataset

(0) Share

Report

Posted on by PowerRon

Hi

I am new to Power Automate.
We started building our first Power BI dataset. In the end we will have many.
We can use Scheduled Refresh in Power BI to refresh those datasets.
But maybe Power Automate is even more handy. Because then we can refresh once the table in our data warehouse is completely updated.
I saw you can initiate the refresh using SQLServer when an item is updated or created.
But this update or create refers to a table, not a row in a table. As far as I understood.

Suppose I have 40 datasets, then I would like to have ONE table in SQLServer with 40 rows. Each row containing two columns: a dataset name and a date. And when the date is updated in a specific row the Power BI dataset mentioned in the first column is refreshed. Is that possible? Or is the Power Automate trigger based on table level and not row level?

Regards
Ron

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

SPOD 63 on at

Like (1)

Report

Hi Ron, I've been thinking about this too but haven't implemented yet. Have you seen this video, is this what you want to do? https://youtu.be/pJjILoOUl1Y

There is a clear explanation of refreshing a power BI model from when a ETL process completes using a SQL trigger table.

Was this reply helpful? Yes No
PowerRon 40 on at

Like (0)

Report

Hi @SPOD

The video is very clear indeed. But it uses multiple trigger tables. An insert/update in a trigger table will initiate the refresh of one or more datasets. I was looking for the possibility that the insert/update of a specific row in a ONE GENERAL trigger table could do the same.
But don't think it is possible.
On the other hand, the trigger tables are small.
Think I have to stick to what the video shows.

Thnx

Was this reply helpful? Yes No