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!

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Richard77 ,

 

Please try to disable "load" of the table and apply. After that, enable "load" and apply again. Can this help?

Please note that, this will delete all calculated columns/measures of the table.

 

In addition, if copy the table into excel and then import it, will the same issue occurr?

 

 

 

Best Regards,

Icey

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

    Dear Icey,

     

    my apologies, i thought i replied to your message but apparently something went wrong.

    I've tried your option to disable and then enable the load, but that did not change anything. Also downloading the data into Excel gave the same result (6 rows, same as in the Power Query after filtering) so i assume that importing the data goes as expected.

     

    I did make some screenshots that might be helpful:

    OneDrive 

     

    Cheers,

    Richard

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Richard77 ,

       

      I can't reproduce your issue. 

      Could you check if all rows show in Power BI Desktop Data View, not Report View? 

       

       

      In addition, please check if any other slicers, filters or visual interactions affect the result.

       

       

      Best Regards,

      Icey

       

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

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

        Dear Icey,

         

        there is no 'header' table nor a 'parent-child' relationship. So far, together with a developer, we have confirmed that the data in D365 is correct and has a unique column.

         

        Adding an index column does not work (404 rows become 360), 'Group by' does not work (it leaves 404 unique rows). 

        I have found one solution that works, but i'm not very confident that this should be it, and that is when i merge the table 'WorkerEntity' with the applicable 'WorkerHolidayBalanceEntity' based on the column personnel number. Adding simply the name of an employee in 'WorkerHolidayBalanceEntity' via this merge i get all the applicable rows (404) in the report view.

         

        So we now have a workaround but no solution for the issue.

         

        Cheers,

        Richard