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

[emmz18]

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

[emmz18]

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 

[amitchandak]

@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.