Limited number of attributes retrieved from OData tables through Power BI

Products

• Clarity PPM SaaS

Issue/Introduction

Imported tables in PowerBI have fields alphabetically ordered, but for each table only a certain number of them are extracted.

 

Environment

v16.x

Resolution

Make sure the attributes from the object and parent object are enabled for Data Warehouse.

Try to use end point similar to this and see it it returns full data.

https://<your-odata-service-url>/<entity-set-name>?$select=*