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,

ibarrau's avatar
ibarrau
Super User
3 years ago

Hi. If you want to connect a PowerBI Desktop to a PowerBi Dataset published on Service. Just get data from Power Bi Dataset and don't use AnalysisServices conector with the address powerbi://api.powerbi.... Unless you know what you are doing and you have your reasons, you shouldn't do that.

Connecting a Web instance of Anaysis Services shouldn't need a gateway. Are you sure that's the only source? try checking Data Sources Credentials on the same screen. It might just need to edit credentials in order to work. PowerBi won't recognize the credentials automatically because it's an Analysis Service instance and not a powerbi dataset.

I hope that helps,