Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a report linked to a OData feed where i pass the API key name as a parameter like this :
Source = OData.Feed("https://apiurl.com/" & "/api/v1", null, [ApiKeyName="apikeyname"])
This worked perfectly fine at first but suddenly it started giving an error on one particular table in the feed.
I can access the table, but once i filter it or remove columns all columns status bar turns red and clicking on the filter dropdown I can see this error message at the bottom:
[DataSource.Error] OData: Request failed: The remote server returned an error: (414) URI Too Long. (URI Too Long)
Trying to reference this table from another table causes the query to fail with this more helpfull error message:
DataSource.Error: OData: Request failed: The remote server returned an error: (414) URI Too Long. (URI Too Long)
Details:
DataSourceKind=OData
DataSourcePath=https://apiurl.com/api/v1/TableName
Url=https://apiurl.com/api/v1/TableName?x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-odataapikey="apikeyname"&x-co-od...
So obviously there's something wrong with the URL PowerBI sends out, but I have no clue why it's repeating the parameter so many times. I have no experience using OData as a source and I can't find anything online about what could cause this. The other tables in the feed still work perfectly fine so I really don't know what to do.
Any help would be appreciated.
For future reference, this was solved by deleting some unused columns in the table and filtering the remaining table on a IDcolumn instead of the IDName column. No clue as to why that fixed it or what was wrong with it in the first place.
You are supposed to include the api key placeholder in the base URL. Please read the documentation again.
I've read both the web service and odata documentation 20 times now and still can't see what I'm doing wrong. I can't find anything about putting it in the base url. It only says to pass it using the ApiKeyName parameter like I do.
And the example looks exactly like how I do it.
Web.Contents("https://contoso.com/api/customers/get", [ApiKeyName="api_key"])
I can access all other tables perfectly fine, even the one giving me trouble only gives the error after I try to filter it. This just started this week, before that everything worked perfectly .
Check out the July 2025 Power BI update to learn about new features.