cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dtgold Frequent Visitor
Frequent Visitor

'Credentials Provided Are Not Valid' error when loading HTML file from Sharepoint Online

This problem has been driving me crazy, so I'm hoping the community might be able to help...

 

SCENARIO:

- I have a Sharepoint Folder source, from which I can successfully load XLSX and CSV files. Power BI stores my credentials (an Office 365 organizational account, which is an owner of the Sharepoint site containing the folder).

- I need to get data from an HTML file which contains lots of tables.

- Using Power BI Desktop, I can see the HTML file in the Sharepoint Folder. However, when I try to load the file, I receive the error "The credentials provided are invalid".

- To be clear, this doesn't happen when trying to load other file types - only HTML files.

 

WHAT I'VE TRIED:

- Loading the same HTML file from my local computer works fine. This suggests that the problem has something to do with the way Sharepoint Online presents HTML files to Power BI.

- Re-entering my Office 365 / Sharepoint credentials (did not help).

- Re-building the query (did not help).

 

The only alternative I can see is to convert the HTML file into an Excel spreadsheet, however this would cause problems for data processing as I would need to group the data back into its original tables. The benefit of importing the HTML file is that I can identify the tables before expanding them.

 

Any suggestions would be greatly appreciated. Thanks for your help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: 'Credentials Provided Are Not Valid' error when loading HTML file from Sharepoint Online

@dtgold,

I can reproduce this issue. It seems that  Power BI Desktop can't recognize the credential when connecting to HTML files in SharePoint online site. 

As a workaround, I would recommend you put all the HTML files in a server folder, then use Folder connector in Power BI Desktop to connect to the data source.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: 'Credentials Provided Are Not Valid' error when loading HTML file from Sharepoint Online

@dtgold,

I can reproduce this issue. It seems that  Power BI Desktop can't recognize the credential when connecting to HTML files in SharePoint online site. 

As a workaround, I would recommend you put all the HTML files in a server folder, then use Folder connector in Power BI Desktop to connect to the data source.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dtgold Frequent Visitor
Frequent Visitor

Re: 'Credentials Provided Are Not Valid' error when loading HTML file from Sharepoint Online

Thanks Lydia (and sorry for the delay getting back to you). I'll look into the options for a workaround like the one you suggested.

 

It would be great if the developers could address this in the future, as it seems like it's not 'as-expected' behaviour.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 126 members 1,627 guests
Please welcome our newest community members: