Prolem in making Relationship in Hybrid model.

[mohsin-raza]

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 

[ToddChitt]

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.

[mohsin-raza · Accepted solution]

@ToddChitt 

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.