PowerBI Pro - Trigger DataSet Refresh (SSIS, SQL, PowerShell) without Azure License "Adminstrator"

[ismailc]

Good day,

Please help, I have powerbi pro and would like toc ontrol the dtaset refresh of the service app.

Currently the app refreshes regardless of SSIS jobs balancing/failure/completed.

I had a look at powershell and ssis component, registered the azure app etc but i dont find in powershell nor ssis external component due to Azure requiring Administrator approval. My company does not have Azure license.

Please any other way around this or another option? 

Regards

[ismailc]

Thank You Very Much All, I have logged a Ticket with Support!

Unable to Accept a solution

[v-xulin-mstf]

Hi @ismailc,

Did you get your problem solved?
Could you share the solution?

😉

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @ismailc,

Is your issue solved?

If the issue has been solved, please share your solution and adopt it to help others.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @ismailc,

Okay, looking forward your good news!😉

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[ismailc]

Hi,

any update please, does giving global admin access require Azure spcae or license cost as my admin is not keen due to space/licening cost

i am under the thinking its only granting the app via azure access to the tenant

?

[v-xulin-mstf]

Hi @ismailc

You can contact MS support as:

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[ismailc]

Thank You for assisting,

Both the above methods are the ones i am referring too.

In the ssis componenet & powershell an API is needed to be registered on Azure.

I have registered but powershell & component does not pickup the registered API

i come to the point where Azure Administrator is required to approve the API and i dont have the license.

My license owner said we dont have azure license hence why i cant properly register the API

Please help?

[v-xulin-mstf]

Hi @ismailc,

Here is the required scope of Refresh Dataset API.

So you need to add permission in Azure Potal:

Grant admin consent confirmation:

Please refer the official document for detials.

Best Regards,
Link

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

[ismailc]

Thank You, but im still unabe to pickup the the API using ObjectID or ClientApplicationID

I set the graph permission and even more permissions on the PowerBIServices as well powerbiapps

Please Help, I really need to get this working

Today y datafeed failed but PBI scheduled refresh indicated the data was the latest as it refreshed. I am losing my audiance

[v-xulin-mstf]

Hi @ismailc,

Have you granted admin consent confirmation?

You will see the status as:

Best Regards,
Link

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

[ismailc]

Thank You for Assisting!

The option for me is Disabled/Greyed out > what do i do now?

[v-xulin-mstf]

Hi @ismailc

In your case, to grant tenant-wide admin consent from App registrations, you need to sign in to the Azure portal as a Global Administrator, an Application Administrator, or a Cloud Application Administrator.

For more information, please refer to: Grant tenant-wide admin consent to an application - Azure AD | Microsoft Docs

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[ismailc]

Thank You but my administrator says he is unable too, Needs an Azure account

How now, any other ideas please?

[v-xulin-mstf]

Hi @ismailc,

Based on my test:

I registered an app with user role.

PS: You can check your role in Azure AD as:

When i set API permission:

Then i log in a account with global admin:

It works in my environment.

If the issue is still not resolved, please contact MS support.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[ismailc]

Hi,

i done the below and sent on to my administrator.

Replies says azure requires space at a cost > Is this True?

I dont think so, its simply granting access to the tenant via Azure

Thanks

[v-xulin-mstf]

Hi @ismailc,

Maybe you can use this SSIS component to trigger DataSet Refresh without Azure License.

Best Regards,
Link

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

[selimovd]

Hey @ismailc ,

you can trigger a refresh with a Refresh API in Power Shell:

Announcing Data Refresh APIs in the Power BI Service | Microsoft Power BI Blog | Microsoft Power BI

And here an example script:

powerbi-powershell/manageRefresh.ps1 at master · Azure-Samples/powerbi-powershell (github.com)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic