Forum Discussion

Richard77's avatar
Richard77
Icon for Resolver I rankResolver I
5 years ago
Solved

Query editor shows rows but data is not available in data view

Hi all, We have recently started using D365 for Finance. To create visualisations and analyse data we use Power BI which we connect to CDS/Dataverse. The issue we encounter is that in the Power Que...
Need Help
  • Richard77's avatar
    Richard77
    5 years ago

    Dear all,

     

    one of the issues we found is that in a certain table an array was present and CDS did not handle this the way it was expected. Instead of using CDS we now use ODATA (and manipulated the applicable table), which allows us to link to the necessary data/tables. Using ODATA, in our case, also solves some other random issues like Timeouts.

     

    Thank you Icey and lbendlin for helping on this topic!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

The Power BI visuals will ALWAYS try to aggregate everything.  If you don't want that you need to add unique columns (like an index column) to the visual. For good measure also enable the "show items with no data"  feature.

  • Richard77's avatar
    Richard77
    Icon for Resolver I rankResolver I
    5 years ago

    Dear Ibendlin,

     

    thank you for your help. Unfortunatly this did not help. D365 already offers a unique index column and next to that, we have tried to add an extra index column. The results were still the same.

     

    My thoughts are heading towards an issue where Power BI does not handle the processing of Dataverse data correctly.

     

    Cheers,

    Richard