Forum Discussion

Eric79's avatar
Eric79
Frequent Visitor
3 years ago

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. ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.

Eric79's avatar
Eric79
Frequent Visitor
3 years ago

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