Forum Discussion

barakb32's avatar
barakb32
Advocate I
5 years ago
Solved

Ideal Data Source for Power BI

Hello, We intend to build a DWH and build connect Power BI to this DWH. The IT department asks if we prefer the DWH as an SQL on Azure VM or as an Azure Fully Managed SQL. Does it matter from Powe...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi barakb32 

     

    To be honest it does not matter as they are both SQL.


    What I would suggest is to use Azure Fully Managed SQL because you will not need a gateway to refresh the data from your DWH into Power BI. As well as all the other good things that you get with cloud software.

GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi barakb32 

 

To be honest it does not matter as they are both SQL.


What I would suggest is to use Azure Fully Managed SQL because you will not need a gateway to refresh the data from your DWH into Power BI. As well as all the other good things that you get with cloud software.