Forum Discussion

emmz18's avatar
emmz18
New Member
5 years ago

Teams CQD when I try to switch to Import method rather than Direct Query no data is retrieved

Hi - I am trying to use the Microsoft CQD which as per guidance I initially set up as a Direct Query - due to limitations on data transformation I have tried to switch to Import - when I do this there is no data coming through to the Query1 table

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    emmz18 , when you change it import mode, make sure data load pop up has come and data is loaded. Else you should see the pending changes bar on top.

     

    Or Open power Query and check do see any error, if yes try to resolve that.

  • emmz18's avatar
    emmz18
    New Member
    5 years ago

    It seems to be the volume of data from the CQD that was causing the issue when I removed a number of columns and added some filters it will preview data in the power query. However when I tried to apply changes in power bi I get CQD Error 3 - this error message does not seem to be listed in the CQD data notes so I am unsure if what the issue is? 

    for context the end goal is to get data from CQD into a SQL DB so any suggestions on the best way to do this would be appreciated