cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Connect to web data via login

Good afternoon

I need help. I have a system that I access via web (with login) and I extract reports or I get tables on the screen that I can then copy to switch to excel and then to power bi.

I try to access directly with power bi and I get out that I need login, but using the available options (basic, windows, anonymity), I can not access. The option to initiate organizational session tells me that it is not available for that resource.

This website is operational with firefox only,I do not know if it is important.

Could someone help me?

Thank you very much in advance

1 ACCEPTED SOLUTION
negi007
Super User
Super User

@Syndicate_Admin when you are connecting to the web data there are different type of accesses available. 

 

The available authentication methods for this connector are:

  • Anonymous: Select this authentication method if the web page doesn't require any credentials.

  • Windows: Select this authentication method if the web page requires your Windows credentials.

  • Basic: Select this authentication method if the web page requires a basic user name and password.

  • Web API: Select this method if the web resource that you’re connecting to uses an API Key for authentication purposes.

  • Organizational account: Select this authentication method if the web page requires organizational account credentials.

in my opinion you can use organization account, in cases where data is available in Microsoft cloud/services only. If your data is available in any third-party website, then you would need credentials of that website to be able to access the data from powerbi.

 

refer to below links for help

https://docs.microsoft.com/en-us/power-query/connectors/web/web

 

https://docs.microsoft.com/en-us/power-query/connectors/web/web-by-example

 

https://docs.microsoft.com/en-us/power-query/connectors/web/web-troubleshoot#authenticating-to-arbit...

 

 

 

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

1 REPLY 1
negi007
Super User
Super User

@Syndicate_Admin when you are connecting to the web data there are different type of accesses available. 

 

The available authentication methods for this connector are:

  • Anonymous: Select this authentication method if the web page doesn't require any credentials.

  • Windows: Select this authentication method if the web page requires your Windows credentials.

  • Basic: Select this authentication method if the web page requires a basic user name and password.

  • Web API: Select this method if the web resource that you’re connecting to uses an API Key for authentication purposes.

  • Organizational account: Select this authentication method if the web page requires organizational account credentials.

in my opinion you can use organization account, in cases where data is available in Microsoft cloud/services only. If your data is available in any third-party website, then you would need credentials of that website to be able to access the data from powerbi.

 

refer to below links for help

https://docs.microsoft.com/en-us/power-query/connectors/web/web

 

https://docs.microsoft.com/en-us/power-query/connectors/web/web-by-example

 

https://docs.microsoft.com/en-us/power-query/connectors/web/web-troubleshoot#authenticating-to-arbit...

 

 

 

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!