KnowledgeBase - I get an authentication error when trying to import REST data into Excel 2019, Power BI, or Office 365
Article

I get an authentication error when trying to import REST data into Excel 2019, Power BI, or Office 365

« Go Back
Products
Webtrends OnDemand
Webtrends Analytics 9.X
Symptoms
When attempting to import REST data into Excel 2019, Power BI, or Office 365 you receive an authentication failure.
Cause
Microsoft deprecated the use of Basic Authentication for HTML data in Power BI and Office 365 on November 1st, 2018. The subsequent version of Excel (2019) also contains these restrictions.
Workaround
Changing the format from HTML to CSV will resolve the issue. There is no real functional difference in any of the above listed software. 
 
Resolution
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255