Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Connect PowerBI to Azure SQL Database through on prem gateway

I have a report that uses Azure SQL database as a datasource.  I want to setup a scheduled refresh, but we do not want to expose the Azure SQL database to the public internet.  We tried using the on ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Did you choose to allow your cloud connections to be served by the gateway?

     

     

  • lbendlin's avatar
    lbendlin
    1 year ago

    That test is not always conclusive. Better verify with a real data transfer.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi @rcpbi ,

 

I'm glad to hear the new report works with the gateway. It seems the original .pbix file might have retained outdated metadata or cached settings. This can happen sometimes, and starting fresh often resolves it.

Thanks again to @lbendlin  for the helpful insights. If this solution resolves your issue, please mark it as accepted to help others with similar questions.

 

Thankyou.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.