direct Query and un-unique data

[Anonymous]

Hi ,

i Have two table which have un-unique data . i created a new key table to make relation between both table . i followed-up steps on this vedio https://www.youtube.com/watch?v=vAvQ8pCnWDk&feature=youtu.be

But got below error .any advise

Failed to save modifications to the server. Error returned: 'Partitions that contain a full dataset (not sampled data) have to be configured for DirectQuery and Full DataViews, or use Import query mode to retrieve data. This model appears to have partitions that are non-compliant. Please check partition configuration.
'.

[msornakumar]

Hi  ,

  It looks like the video shows example from import data. The product id bridge table being created involves the calculated table generated during the data import. Not sure if this is supported in Direct Query mode.