Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Hello,
We have recently managed an issue which resolution may help to most of you. For so, we would to share it here. It is about data source connection in Power BI Desktop application and in our case we were using OData Feed connection. If you get the following error "The user was not authorized", the first thing you must do is check if the credentials you are using are correct. However, there are sometimes that you have checked that credentials are correct, that it had worked for past connections on the same desktop application and you get stuck doing the connection again and again without been able to connect.
On those cases, we detected that Power BI is trying to reuse an old connection stored on the application cache. Try to delete the cache and the old data source connections related. You can do it, going to "File --> Options and Settings" in the following way:
1. To delete cached files go to "File --> Options and Settings --> Options --> Data Load":
2. To delete the old data source connection related, go to "File --> Options and Settings --> Data Source Settings" select the related connection and click on delete:
You can also edit the connection to check if the information in the data source matches with the one you are trying.
Hope it helps!
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in