Forum Discussion

UserBUG's avatar
UserBUG
Regular Visitor
8 years ago

How to get live data from a REST API requiring OAuth 1.0 authentication?

This question does not pertain to Power Bi Desktop, where most authentication methods can be replicated in Power Query. The question pertains to Power Bi Online where I would like to pull data from a...
Need Help
Tutorial Requests
UserBUG's avatar
UserBUG
Regular Visitor
8 years ago

Thank you for your feedback, Lydia!

 

Said approach would require to refresh data continuously through Power Bi Desktop, though.

My intention is to publish the report (via iFrame) to users (without any Power Bi Desktop).

For that purpose, the report needs to be refreshed online whenever a user access it or on a scheduled basis (at least every 15 minutes).

How would I go about it in this case?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

UserBUG,

After you publish PBIX file  to Power BI Service, you can set schedule refresh for your dataset. To schedule data at least every 15 minutes, you can purchase Power BI premium, otherwise, you are limited to refresh datasets up to 8 times a day.

Regards,
Lydia

  • UserBUG's avatar
    UserBUG
    Regular Visitor
    8 years ago

    Dear Lydia,

     

    That won't work work with OAuth 1 which requires a logic in the Web Requests, specifically a new Timestamp and Nonce for every call.

    Can you confirm that Refresh works with Web Queries with OAuth 1?

     

    Best regards,

     

    Gabriel

    • naveenupadh's avatar
      naveenupadh
      New Member
      8 years ago

      hi Gabriel, have you had the solution yet? I am also planning to connect Power Bi with LivePerson Rest APIs using OAuth 1.0, is this possible?

      • UserBUG's avatar
        UserBUG
        Regular Visitor
        8 years ago

        No solution to date. I'm currently looking into other BI solutions with OAuth 1.0 built in. I like the Power Bi visuals more, but guess Web Service Requests are limited to OAuth 2.0 and Basic.