Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

gateway for azure sql

do i need data gateway to refresh power bi report using azure sql database

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi powerbiexpert22 

    Thank you for reaching out Microsoft fabric community forum.
    As mentioned by hackcrr An on-premises gateway is not required. Azure SQL DB supports a cloud gateway connection, where you can configure it directly and specify it for your semantic model. In addition ,

    You need a data gateway if you are connecting to an on-premises SQL Server database (not Azure SQL Database).
    Best regards,
    shamili.v

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi powerbiexpert22 

    Thank you for reaching out Microsoft fabric community forum.
    As mentioned by hackcrr An on-premises gateway is not required. Azure SQL DB supports a cloud gateway connection, where you can configure it directly and specify it for your semantic model. In addition ,

    You need a data gateway if you are connecting to an on-premises SQL Server database (not Azure SQL Database).
    Best regards,
    shamili.v

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi powerbiexpert22 

    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.