Forum Discussion
Dynamics 365 OData error with Power BI desktop
Excellent, that got it working. Thanks.
9.0.2.751 also began enforcing 10+ calculated field query limits in powerbi (some other apps have had this limitation for a while now).
We kept having intermittent issues with powerbi the last few months so we made the move to azure sql data export service. Not too hard to do (Have to change your reports a bit or a lot depending on the report/datasets). Azure sql refreshes incredibly faster and offloads the resources from dynamics if you have a lot of powerbi reports/queries like we did.
I am new to D356 (Online) and PowerBI. I am tring to bring in an entity into PowerBI desktop and get this error. Yes, I have more than 10 calculated fields. I don't need all the fields in the PowerBI query but I can't load the entity to reduce the columns. What do I need to to begin to shape the query on this entity?
You could try adding a select statement to the URL to handpick the fields you want - For more information search for $select here https://www.odata.org/getting-started/basic-tutorial/