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

Hi! Thank you for your response!

Let me explain a full picture step by step.

I have a dataset B that contains some historical data and does not need to be refreshed. So, in each query in Power Query Editor I turned off report refresh. Then I published this dataset B to the Service. 

Then I have a dataset A that contains fresh data and needs to be refreshed. Also, it must have historical data. So, while I am in dataset A, I connected to the dataset B through "Get data -> Power BI datasets" and chose dataset B. 

To put dataset A on scheduled refresh, I go to the gateway connection settings. This is when things get unclear and dataset B which acts as a data source requires adding to gateway

Why does it happen?