Combining Direct Query and imported Data is not supported

Question

I am trying to use the&nbsp;Pre defined power BI Models from Dynamics 365. I followd all the steps as indicated in this&nbsp;Microsoft Site.I've installed the patches on the Server and when i change the server as mentioned and trying to refresh,I Cant access Power BI content developed by Microsoft.I got the below error"Combining Direct Query and imported Data is not supported" although its a Direct Query.&nbsp;&nbsp;&nbsp;

v-chuncz-msft · Answer

sandeepk66,
&nbsp;
Open the Query Editor, you'll see a detailed error message.

sandeepk66 · Answer

Expression.Error: The key didn't match any rows in the table.Details:Key=RecordTable=Table

v-chuncz-msft · Answer

sandeepk66,
&nbsp;
Go through each step of the query to troubleshoot this problem.

Forum Discussion

Combining Direct Query and imported Data is not supported

3 Replies

Related content

Tables combine

Campaign Voucher FAQ & Support

Data Combining Problem

Combine Column

Dynamic RLS combination