Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
In my model I have one fact table and one calendar table both are in direct query mode, also having relation based on date column, however when am trying to create a simple table visual where i have used some columns from fact table and used date fields from calendar table am getting below error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @nm17844 ,
Power BI doesn’t support Direct Query for any types of join other than Left Join. If you’re using a different type of join in your query, consider changing it to a Left Join. Certain statements are also not supported in Direct Query Mode. If you’re using such statements in your query, consider changing the data mode or modifying the query.
You may try to convert the calendar table as import mode if you could.
Best regards.
Community Support Team_Caitlyn