I’ve had a PowerBI report running in our sandbox, pulling our Logbook data. It works, and then it doesn’t work. We are implementing Logbook in production this week, so I have pulled up our report that is pointing to our sandbox, made a copy, and am trying to point the copy to production. After numerous attempts at trying to make that work, I realized the sandbox connection isn’t working any longer.
- If I use “Basic” credentials, I can get the Portfolios OData data, but the logbook data throws this error: “Expression.Error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer”
- If I change the Data Source Settings to use anonymous, and then refresh, I still get the Authorization error, plus I have the error on the Portfolios data “We couldn’t authenticate with the credentials provided. Please try again.”
I feel like it’s an endless loop!
Anyone have any tips?