Forum Discussion

swarnikasinha's avatar
swarnikasinha
Icon for Helper I rankHelper I
3 years ago
Solved

Data Gateway

Hi All I am facing difficulties with Refreshing a dataset in Power BI Service. Datasource is Azure sql database I have used import mode. I need to set up refresh.    Which Datagateway I should Ins...
Dataflow
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey swarnikasinha ,

     

    using Azure SQL DB does not require using an on-premises gateway. A gateway is only required when you have to meet specific security requirements.

    Can you provide the error message from the refresh history, make sue that you expand the detail hint?

    Did you adjust the "Edit credentials" (see the below image) after you published the report to the workspace. This is required as "Publish" will not publish the credentials you are using on Desktop to avoid man-in-the-middle interference.



     

     

     

     

     

     

     

     

     

     

    Hopefully,  this provides some ideas on of how to tackle your challenge.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey swarnikasinha ,

 

using Azure SQL DB does not require using an on-premises gateway. A gateway is only required when you have to meet specific security requirements.

Can you provide the error message from the refresh history, make sue that you expand the detail hint?

Did you adjust the "Edit credentials" (see the below image) after you published the report to the workspace. This is required as "Publish" will not publish the credentials you are using on Desktop to avoid man-in-the-middle interference.



 

 

 

 

 

 

 

 

 

 

Hopefully,  this provides some ideas on of how to tackle your challenge.

 

Regards,

Tom