Forum Discussion
How to get live data from a REST API requiring OAuth 1.0 authentication?
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-to-use-oauth/
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
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?
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,
LydiaDear 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
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?
