Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In this task there are two directQuery models using PowerBI Dataset and One import Excel file.
One making relationship between Excel table and more than one table in DirectQuery models get the following error msg "To filter a remote power bi data source or Analysis Services data source by reaching more than one table within the island ,which is not supported" .
Can some body help to solve the problem.? I have powerbi pro
Solved! Go to Solution.
Thanks for your comments. The theorical study says that
"In composit/Hybrid model in Powerbi usee the concept of islands as an analogy of where data is queried to understand how data models work in practice.
If you use two DirectQuery data sources, then each of them is a separate island. In contrast, all imported data resides in the same island regardless of where it originally came from, because all imported data is queried from memory. When you connectto data on the same island, you will have the fastest results since you don’t need to “swim” to another island.
You can see different kinds of relationships ordered from fastest to slowest in the following
list:
1:One-to-many intra-island relationships
2: Direct many-to-many relationships
3: Many-to-many relationships with bridge tables
4: Cross-island relationships"
This concept solve my problem by making relationship between two DirectQuery source and One import datasource.
You can't mash up data between the two. I had a very similar problem. I had a SQL source that simply returned way too much data, and I wanted to filter it by doing a Power Query MERGE (INNER JOIN ) to an Excel query that listed the Customers I wanted. I got a similar error.
I bet you cannot mash up the two dissimilar queries.
Proud to be a Super User! | |
Thanks for your comments. The theorical study says that
"In composit/Hybrid model in Powerbi usee the concept of islands as an analogy of where data is queried to understand how data models work in practice.
If you use two DirectQuery data sources, then each of them is a separate island. In contrast, all imported data resides in the same island regardless of where it originally came from, because all imported data is queried from memory. When you connectto data on the same island, you will have the fastest results since you don’t need to “swim” to another island.
You can see different kinds of relationships ordered from fastest to slowest in the following
list:
1:One-to-many intra-island relationships
2: Direct many-to-many relationships
3: Many-to-many relationships with bridge tables
4: Cross-island relationships"
This concept solve my problem by making relationship between two DirectQuery source and One import datasource.