How To Swap REST API Bearer Token in Power Query To Allow Easy Data Refresh in Power BI

Поделиться
HTML-код
  • Опубликовано: 2 дек 2024

Комментарии • 17

  • @BILingualAnalytics
    @BILingualAnalytics  Год назад +1

    Have you used this method before? Let me know here 👇👇👇

  • @duncanvanpagee5277
    @duncanvanpagee5277 10 месяцев назад +1

    Thanks for the video, I am looking to do the exat same thing but instead with a POST request. What do I need to change in Power BI?

    • @BILingualAnalytics
      @BILingualAnalytics  10 месяцев назад

      What data/information would you like to insert/update with a POST. request in this scenario?

  • @controloverreports
    @controloverreports Год назад +1

    Very exicted to see the more robust way !! I am trying to get a simple Power BI report with current users with their rights on APPS, Workspace and reports. Is not (yet) avaible in the admin workspace in the purview dataset in power bi. .... Can't wait to see your solution so I can use it at my clients

    • @BILingualAnalytics
      @BILingualAnalytics  Год назад +1

      Glad you are getting more hands-on with REST API! It will come in 2-3 weeks, so stay tuned!

  • @ashikshaik1205
    @ashikshaik1205 11 месяцев назад +1

    Hey, I didnt understand how the bearer token refresh itself. In this video you have manually pasted the bearer token from microsoft learn. Can you help me how to get the new or refreshed bearer token using power automate? Awaiting for your help.

    • @BILingualAnalytics
      @BILingualAnalytics  11 месяцев назад

      After an hour of inactivity, the token will expiry. Hot swapping refers to the fact that you can swap out the token to a new one.

    • @ashikshaik1205
      @ashikshaik1205 11 месяцев назад +1

      @@BILingualAnalytics Thanks for the reply. Is there a way i can get a new token automatically when the older one expires?

    • @BILingualAnalytics
      @BILingualAnalytics  11 месяцев назад +3

      @@ashikshaik1205 without logging in to MS Learn the answer is NO. However, I have a video in the making on how to create a more robust solution where you don't need to rely on the bearer token. Stay tuned!

    • @ashikshaik1205
      @ashikshaik1205 11 месяцев назад +1

      @@BILingualAnalytics Great! Waiting for the video😎

    • @shitalpisolkar5176
      @shitalpisolkar5176 4 месяца назад +2

      @@BILingualAnalytics HI, Have you released this video ?

  • @nuredinomer690
    @nuredinomer690 10 месяцев назад +1

    Thank you for this video it is helpful. but I have a question about the data source API static so to make it Dynamic

  • @rstiekema
    @rstiekema 6 месяцев назад +2

    Where is your video about automated token generation for the powerbi rest api?

  • @nuredinomer690
    @nuredinomer690 10 месяцев назад

    Moreover in current values what did you copy bearer token or Api?

  • @vladpylypenko4795
    @vladpylypenko4795 8 месяцев назад +1

    Many thanks for the video! Still I get “Access to the resource is forbidden”. What type of credentials/access permissions you have used?

    • @BILingualAnalytics
      @BILingualAnalytics  8 месяцев назад

      Hey, thanks for the kind words. Do you get that error msg when trying to change the bearer token or right at the first step?