Credential Input Issue for HTML Table Listings

Hi support,

I recently came across this page: https://www.jotform.com/answers/1452433-Username-and-password-when-reading-Excel-report-from-Excel

When it discusses about the use of Web data in Excel's Power Query Editor. I'm attempting to do so too for my created HTML Report Listings:

https://www.jotform.com/table/202371065458050

However, I want this report to be locked behind a password.

I wanted to add that credential information in Excel. Is it possible?

 Even if I removed the password, this error would occur:

DataSource.Error: The remote server return an HTTP status code '500' when trying to access 'https://www.jotform.com/table/202371065458050'.
Details:
    DataSourceKind=Web
    DataSourcePath=https://www.jotform.com/table/202371065458050
    Url=https://www.jotform.com/table/202371065458050

Hi, I'm happy to help you today.

Yes, it is possible to enable password protection for your HTML table report. Just go to My forms page-> select the form-> Click on Reports-> Click on the Pencil button to edit the report-> Enable the Password protection and enter the desired password.

If you already created a password and you're getting the error, please remove the HTML table report and create it again.

Let us know if you have further questions.

Thanks.

Hi Rosa,

Sorry that the answer was a little bit off from what I meant.

What I meant is, I wanted to use Excel's PowerQuery function to 'connect' to the HTML table listing, while having it password protected.

Is it possible?

Unfortunately there is no such provision to connect with Power Query  tool for using HTML table listing. 

BTW,I was able to view the submissions on going to the given path that you provided.

Let us know about the issue if we were not able to grasp.

Feel free to contact.