Forum Discussion

kiril's avatar
kiril
Frequent Visitor
5 years ago
Solved

How to load only required columns

Dear community,   we are building dashboards using CDS and Dynamics as data sources. We load tables like accounts, contacts, activitypointers and activityparties. Those tables have a large amount o...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi kiril ,

 

Currently power bi doesn't support importing specific columns into power bi desktop when connnecting to CDS and Dynamics. However, you can first import these columns into database(e.g.: sql server) and then use sql query to import specific columns into power bi.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kiril's avatar
kiril
Frequent Visitor
5 years ago

Thank you. Unfortunately, SQL server is not an option for us.

 

However, the following approach solved my problem:

 

  1. Create a new query
  2. Define the OData query as needed, instead of navigating from the top of the orgnisation:

= OData.Feed("https://org.api.crm.dynamics.com/api/data/v9.1/accounts?$select=accountid,name", null, [Implementation="2.0"])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi kiril ,

     

    Great! Thank you for letting me learn new knowledge.

     

    Please accept your own reply as the solution. More people will benefit from it.

     

     

    Best Regards,

    Stephen Tao

  • ravi_609's avatar
    ravi_609
    Helper I
    2 years ago

    Not Working. It is filtered perticular column but other column is also coming with error