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.
Hi,
I was taken dim date table from one dataset and other two tables get from another dataset .
I can create relationship with one table but can't able to create relationship with another table . i was getting werror while i try to create relationship.
Please let us know if have answer.
Hi @Powerbidev1,
The DirectQuery table can only touch 1 active relationship at a time. This is considered a chained dataset. You can link to another table and then link back to your date table but you can't link it together directly.
An alternative is to make your Date table an import and then link the two together.
Hi Hnguy71,
Thanks for response.
I have created date table from powerbi desktop and then tried to make relationship but not working , getting same error .
Can you please give me some other solution. thanks
Hi @Powerbidev1 ,
You can import all your data using the AAS connection and then build your relationships in that manner.
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 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |