Forum Discussion
Trigger dataset refresh by user without license
I am interested in a similar situation. Found the following link about how to trigger a dataset refresh through the Power BI APIs:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
My desire would be to put a little custom console app behind an icon on the user's desktop so that when they double-click the icon, it triggers the refresh in Power BI web.
I have successfully created a console app after following the above link and others to which it referred, but alas, my console app only works when I am logged into the box from which I run this newly created app.
It is relying on Azure Active Directory for the authentication piece. If your company is using AAD as well, seems to me that you could set up this user to access the dataset in Power BI, and while she would never have to open Power BI and run it, if you user her AAD account to create the required "client Id" (as explained in the above article), then the console app behind an icon would work for your situation. As for me, I have multiple users and do not want to create a "client Id" for all of them, so I am looking at something called a "Service Principal" to fill that roll but don't yet know enough about whether it will work.
Good luck.