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 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

Need Help

17 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    Unable to Accept a solution

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous,

       

      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!

       

       

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous,

       

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

      Hi Anonymous,

       

      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!

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    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
     

     

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

    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.

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

      Hi Anonymous

       

      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!