How to get data from password protected website?

Hi Anonymous ,

You may try Get Data > Web from the Home ribbon and do research into The Advanced Editor in Power Query Editor.

Check the M query in advance editor and find if there's any papameter that connect with password.

Best Regards,

Jay

Hi Anonymous thanks for your suggestion - do you mean connect via API in Power Query? This would mean I have to create a dynamic url, which prevents me from automated refreshing in Power BI Service. In the meantime, found out two other options to import data from password protected website:

• Create custom connector
• Use Power Automate to get the data and then import them into Power BI

Hi,

does anyone know the solution for this question ?