Forum Discussion

rbmanian75's avatar
rbmanian75
New Member
10 years ago

Power BI Embedded using On Premise Gateway Sql Server data source

Hi,   We have installed the on premise gateway and added our sql server to gateway data sources. and the test connection is working well.   how can we set the report to use on premise gateway sql...
Need Help
checo3131's avatar
checo3131
New Member
9 years ago

Did youo find a solution for this scenario? I´m facing the same issue, it seems that PowerBI embedded only works with DirectQuery which only works with SQL Databse online aka Azure database (OnCloud)

  • rbmanian75's avatar
    rbmanian75
    New Member
    9 years ago

    No i did not find any solution. we are just using the azure database at present. It is in the to do list of power bi team. 

     

    Thanks

    • Sunkari's avatar
      Sunkari
      Responsive Resident
      9 years ago

      Currently,Power BI Embedded doesn't support direct query/scheduled refresh for on-premise databases