Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Odata not loading properly

I had an odata feed that worked previously, but stopped working on my second power bi. Now my original one doesn't work. How do I resolve this?
Need Help
foodd's avatar
foodd
Community Champion
3 years ago

It would be helpful to add a work-in-progress  Power BI file to allow members of the Forum to understand the state.   When an OData feed that previously worked stops working in Power BI, there could be several reasons behind the issue. Here are some common troubleshooting steps:

 

  • Check OData Service Availability (Is the service down?)
  • Verify URL and Authentication (Is the URL correct, and is the authentication correct?)
  • Test Odata Connection Outside Power BI (Excel Power Query)
  • Clear Data Source Settings including permission and cache (Options and Settings|Data Source Settings)
  • Check for any changes to network and firewall settings
  • Ensure Power BI is up to date  (this also allows the connector to be the most current)
  • Check for error messages 
  • Republish a fresh copy of the report from Power BI Desktop to the Service
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It started working because someone on my team decided to change the parameters to be anonymous. The new issue I have is that I have a dataset taken from the web and then the same odata feed source as mentioned above. Was able to append them and make a comprehensive dataset on desktop. The issue arises with trying to make it autorefreshing. It says that I don't have the credentials even though it's same credentials I needed for the desktop version. Does that make any sense and how would I be able to resolve