Forum Discussion

fuglphoenix's avatar
fuglphoenix
Frequent Visitor
6 years ago
Solved

problems with directquery to dynamics cds

i've been experimenting with the CDS and direct query, using this guide https://crmchartguy.com/2020/05/29/directquery-cds-from-power-bi/ and it has been working great for a few weeks/months. but su...
Need Help
  • fuglphoenix's avatar
    fuglphoenix
    6 years ago

    lbendlin, i'm not sure I understand what you mean.

    because it does load the data from  db tabel systemuser into dbo_systemuser, which i load directly into the pbi datamodel.

    it looks fine in the powerquery window (ie. i see the data), but as soon as I apply and load it into pbi it breaks.

    unless I switch from directquery to import. that will fix the issue...

     

    okay. this i strange. I was about to get some screenshots of the issue. 

    and despite being broken for a few weeks, and i haven't change anything. it suddendly works...

    i guess that i might have been a problem with cds endpoint

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi fuglphoenix ,

 

I found a video that use the Power Apps visual in Power BI to add/update data in CDS using Direct Query Mode.  You could have a try.

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Visual-for-Power-BI-CDS-Direct-Query-Mode/td-p/1167101

 

 

And I see the comment from https://crmchartguy.com/2020/05/29/directquery-cds-from-power-bi/. There is other user that encounters this issue and he/she changes to import mode as well. Then the report works fine. Maybe it happens because it is preview?  I haven't tried it. If you need to use this way to do. You could create a support ticket to get the dedicated support.

How to create a support ticket in Power BI