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
    Icon for Community Support rankCommunity 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
        Icon for Community Support rankCommunity 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.