Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to add Direct Query relationship between tables if one of them has more than 1M rows?
I have 2 tables in the same SQL DB: one table has 2 rows, another table has 1,1M rows. Whenever I try to add a new relationship between these 2 tables, Power BI Desktop become non-responsive (tried single and both directions). It fails only for Direct Query, works fine when using Import.
Power BI Desktop Version: 2.70.5494.661 64-bit (juni 2019)
Solved! Go to Solution.
Hi @Dmitry ,
I'm afraid that your scenario hit the limitation for direct query mode.
Please have a good look at this document to know more about the limitations for direct query.
Best Regards,
Cherry
Hi @Dmitry ,
I'm afraid that your scenario hit the limitation for direct query mode.
Please have a good look at this document to know more about the limitations for direct query.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |