Importing data from Microsoft Forms to Power BI

[Anonymous]

Hello,

Until last week (April 5, 2022) I was using a Power BI query to fetch data directly from Microsoft Forms.
The Query connected to this source:
Source = Excel.Workbook(Web.Contents("https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=Form_ID"), null, true),

But since last week I get an authorization error when I try to refresh the data, and when I choose to connect with a pro account I get the following error message:
The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer'

After some research I've found this thread talking about the same error, but without a working answer.
https://community.powerbi.com/t5/Desktop/Web-Content-Access-Method-WWW-Authenticate-header-doesn-t/m-p/160348/highlight/true

Can someone help me there?

Thanks!
Pierre

[Anonymous]

Hi @Anonymous ,

This error seems to be caused by your account, please check your account.

In addition, try to clear your caches and certificates.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.