Forum Discussion
OData that was working, stops
I have a OData base dashboard that worked fine for over a year, and today, stopped. I got a BI Service alarm saying that the refresh has fail. When I pull the pbix file this was the message:
It says "We couldn't connect. Exclude your credentials and try again later.".
I try that and didn't work. I don't remember why didn't use Sharepoint List for this case. But is there a way to correct this without changing the datasource? What is causing this?
This refreshes every day, and the first error occured yesterday (Sunday, 12/06/2022 13:03)
Update1: I remember why I use OData. In this case, it queries faster than a Sharepoint List.
So, in the end, my real problem, was that I could not find and delete the old credential saved in my PBI Desktop.
Then I solved by:
- Unintalling PBI Desktop;
- Deleting all REG related to PBI (I dont know if this was really nescessary):
- Delete the file "C:\Windows\prefetch\PBIDESKTOPSETUP_X64.EXE-5921B703.pf" (I dont know if this was really nescessary);
- Reistall PBI;
- Refresh the Query;
- Publish the Dashboard in PBI Service;
- Reset the Scheduled refresh.
1 Reply
So, in the end, my real problem, was that I could not find and delete the old credential saved in my PBI Desktop.
Then I solved by:
- Unintalling PBI Desktop;
- Deleting all REG related to PBI (I dont know if this was really nescessary):
- Delete the file "C:\Windows\prefetch\PBIDESKTOPSETUP_X64.EXE-5921B703.pf" (I dont know if this was really nescessary);
- Reistall PBI;
- Refresh the Query;
- Publish the Dashboard in PBI Service;
- Reset the Scheduled refresh.