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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.