Forum Discussion

sergazyyev's avatar
sergazyyev
Frequent Visitor
3 years ago
Solved

Dataset needs gateway

One dataset (A) is connected to another (B). When I want to refresh the first one (A) I cannot do it because second dataset (B) acts as a datasource and needs a gateway. How to avoid this issue...
Need Help
  • ibarrau's avatar
    ibarrau
    3 years ago

    Ok, now it's making sense. It's a composite model. PowerBi Dataset B + other sources. Are those other sources connected with a gateway? There is an option when using a gateway to allow the dataset use cloud and onpremise sources without requiring a gateway. That one can make conflict if it's not checked.

     

    I hope that helps,

sergazyyev's avatar
sergazyyev
Frequent Visitor
3 years ago

Thank you for your answer!

To add more information, read the following:

When I connect to dataset B through get data from Power BI Dataset it automatically connects to AnalysisServices. 

Here is my lineage:

I want to refresh dataset A but it requires a gateway for dataset B. How to avoid this requirment of adding the gateway?

ibarrau's avatar
ibarrau
Super User
3 years ago

Hi. If you get data from dataset B when creating A as Live Connection like I have said before, then there is nothing to refresh. It should always be the same source from A as B. No gateway, no refresh, just live connection.

If you need a gateway it might be for refreshing B from the SQL Servers if they are on premise.

I hope that helps,