RSS feed Internal Server error

[lizzy]

I am trying to connect to one of the RSS feeds from bizjournals.com (https://www.bizjournals.com/chicago/syndication). I can connect to my desired feed using the "web" connector, and it opens fine in the query editor. Once I have expanded the columns to show the contents of the RSS, I close the query editor and am met with the error:

Web.Contents failed to get contents from [website] (500): Internal Server Error

If I go back to the query editor and try to refresh the table, I get the same error. This happens with whatever combination of selections I made for what the feed contains. I have had success with other RSS feeds in Power BI, and this feed works in Outlook.

Is there anything else I should try? I am having trouble discerning whether this is a Power BI problem or something with the feed itself.

[v-yuta-msft · Accepted solution]

@lizzy ,

The web connector may be incompatible with some of RSS feed. You can try connecting to RSS as an ODBC data source and check if it can work. For more details, please refer to blog below:

https://www.cdata.com/kb/tech/rss-odbc-power-bi.rst

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.