topic DataSet Query Does Not Count As Activity in Developer

DataSet Query Does Not Count As Activity

jmfillman — Fri, 19 Jul 2024 22:44:16 GMT

I have a Power Automate flow that queries a DataSet. It turns out, that does not count as activity and PowerBI disabled the scheduled refreshes. Any suggestions or something I can do with the Flow to count the activity and prevent BI from disabling the scheduled refreshes?

Re: DataSet Query Does Not Count As Activity

Anonymous — Mon, 22 Jul 2024 07:22:57 GMT

Hi @jmfillman ,

As far as I know, we can try to configure Power Automate to trigger.

Here I will give you some suggestions.

1. You can set a trigger such as “When a new email arrives” or “When a file is created.”

For reference:How to Refresh Power BI Dataset Using Power Automate (process.st)

2. You can try Power Automate visual as a button in Power BI to trigger the refresh.

For reference:

How To Use Power Automate To Refresh Data In Power BI – Master Data Skills + AI (enterprisedna.co)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: DataSet Query Does Not Count As Activity

christinepayton — Mon, 22 Jul 2024 22:09:16 GMT

You could have Power Automate run the refresh schedule instead? It can refresh PBI datasets. I don't think there's anything that PA cloud can do that would count as activity, off the top of my head, because it's not a "real" user, its just doing API calls. PA Desktop could, but that's overkill.

Re: DataSet Query Does Not Count As Activity

jmfillman — Thu, 25 Jul 2024 17:34:23 GMT

Thank you I will try this out and see if it counts as activity. I can appreciate the idea that and API call is not a real user, although in my opinion, it should still demonstrate it is being used and needs current data... By design, I try and segregate a DataSet for API's. It is too easy to make a change to a DataSet/Report that has other uses, and ends up breaking the queries.