Web Scrape Pending User Requests from Power BI Service

[dritsche]

Hi there,

Power BI does not have a programmatic way to extract pending user requests through the PBI Service (e.g. via REST API). I'm trying to web scrape the pending user requests page but am having trouble authenticating. When trying accessing the page, I'm redirected to: https://app.powerbi.com/singleSignOn?ru=https:%2f%2fapp.powerbi.com%2f%3fnoSignUpCheck%3d1

My organization uses SSO.

Any ideas on how I access the page above so that I can web scrape the table?

[v-henryk-mstf]

Hi @dritsche ,

It seems unclear what you need, your organization is a single sign-on approach, then you need to access data in the pbi service,, but every time it jumps to a window that requires verification of pbi account permissions is that what you mean?
Looking forward to your feedback.

Best Regards,
Henry

[dritsche]

Hi @v-henryk-mstf , sorry for the confusion.

Based upon my limited knowledge, the authetication protocol used for the Power BI Service is OAUTH2. However, everytime I try to web scrape the page detailing the Power BI access requests, it jumps the link above. It does not give me the option to verify the pbi account permissions.