Forum Discussion
Importing data from web into Power BI
Hi, aks_jo
Based on your description, if you only see the login page column in the data preview, this is usually an indication that Power BI has not yet successfully passed web authentication to access data beyond the login page. There are multiple reasons why this occurs, but the most common reasons are the way the credentials are delivered or the structure of the web authentication. You can try the following to resolve the issue.
1. Ensure Correct Credential Type, make sure you're using the correct credential type for the webpage you're trying to access. Power BI offers different authentication methods, including Basic, Windows, OAuth2, and others. For web pages requiring login, you might need to use Basic or OAuth2, depending on the site's requirements. For more details on selecting the correct authentication method.
2. Use an On-Premises Data Gateway, for web pages that require authentication, especially when dealing with HTML content, using an on-premises data gateway can sometimes resolve issues related to security and authentication. This is particularly true for web connectors that might not directly support certain types of web authentication.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, aks_jo
Based on your description, if you only see the login page column in the data preview, this is usually an indication that Power BI has not yet successfully passed web authentication to access data beyond the login page. There are multiple reasons why this occurs, but the most common reasons are the way the credentials are delivered or the structure of the web authentication. You can try the following to resolve the issue.
1. Ensure Correct Credential Type, make sure you're using the correct credential type for the webpage you're trying to access. Power BI offers different authentication methods, including Basic, Windows, OAuth2, and others. For web pages requiring login, you might need to use Basic or OAuth2, depending on the site's requirements. For more details on selecting the correct authentication method.
2. Use an On-Premises Data Gateway, for web pages that require authentication, especially when dealing with HTML content, using an on-premises data gateway can sometimes resolve issues related to security and authentication. This is particularly true for web connectors that might not directly support certain types of web authentication.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum