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

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

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

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

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

  • @nuredinomer690
    @nuredinomer690 8 месяцев назад +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

  • @controloverreports
    @controloverreports 10 месяцев назад +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  10 месяцев назад +1

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

  • @duncanvanpagee5277
    @duncanvanpagee5277 8 месяцев назад +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  8 месяцев назад

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

  • @vladpylypenko4795
    @vladpylypenko4795 6 месяцев назад +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  6 месяцев назад

      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?

  • @rstiekema
    @rstiekema 4 месяца назад +1

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

  • @ashikshaik1205
    @ashikshaik1205 9 месяцев назад +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  9 месяцев назад

      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 9 месяцев назад +1

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

    • @BILingualAnalytics
      @BILingualAnalytics  9 месяцев назад +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 9 месяцев назад +1

      @@BILingualAnalytics Great! Waiting for the video😎

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

      @@BILingualAnalytics HI, Have you released this video ?

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

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