Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous,

 

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.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous,

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank You for Assisting!

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