Forum Discussion
D365 Odata Error on Power BI using Filter
This error only shows up on certain columns. I am at a 50% success rate. Is this is a known issue or is the code wrong? It could be an issue with D365 but not sure which way to test or fix. Any help is appreciated.
Thanks
4 Replies
Hi Eric79
I don't have much knowledge in D365, so I'm not sure if D365 can accept the following parameter value in the URL. Are you sure this is supported? Do you have any documentation link about this?
If you remove all paramters from the URL, are you able to get data from the basic URL? If it's possible, you can try filtering rows using Power Query instead of passing filters in the URL.
Filter by values in a column - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Standard Odata works with D365. Here is the documentation and it works on many tables and columns. Not sure if it is an entity configuration issue in D365 or Power BI error. It is a large dataset so I would like to filter it before it is imported. The query times prevent refresh if not.
Using Filter Expressions in OData URIs - Business Central | Microsoft Learn
Thanks
I found an article that says filters on dataareaid don't always work. That is the best information I found and went a different direction.
