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

[UserBUG]

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 REST API which requires OAuth 1.0 authentication, something I cannot find in the gateway settings.
What is your recommended approach to pull data from a REST API requiring OAuth 1.0 authentication live every time a user loads or refreshes the Power Bi report?

[v-yuezhe-msft]

@UserBUG ,

You are able to use in OAuth 1.0 authentication in Power Query or Power BI Desktop.

https://www.kasperonbi.com/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-...

Based on your description, do you want to add the project online data source within on-premises gateway and refresh your dataset in Power BI Service? If that is the case, as you are connecting to online data source(Project Online), gateway is not required to refresh your dataset. Go to Settings->Datasets and find your dataset , you should find that Power BI Service connect directly to your data source, after you edit the credential for your data source, you are able to set schedule refresh for the dataset.



Regards,
Lydia

[UserBUG]

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?

[v-yuezhe-msft]

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

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]

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]

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.