Forum Discussion

mak82pk's avatar
mak82pk
Helper I
9 years ago
Solved

Power BI Direct query real-time refresh and data upload

If I am using direct-query for SQL database on my server [not Azure SQL DB] configured by on-premises gateway there is no limit for data refresh? Also, can I get real-time data using the same? When...
Need Help
Show and Tell
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi mak82pk,

     

    How clever you are. :smileyvery-happy:

     

    As the SQL Server database is on-premise data source, the gateway is required. As you use DirectQuery mode, on-premise data gateway is necessary. See: Live connections and DirectQuery to on-premises data sources.

     

    Data source Live/DirectQuery User configured manual or scheduled refresh Gateway required
    Analysis Services Tabular Yes Yes Yes
    Analysis Services Multidimensional Yes Yes Yes
    SQL Server Yes Yes Yes
    SAP HANA Yes Yes Yes
    Oracle Yes Yes Yes
    Teradata Yes Yes Yes

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi mak82pk,

 

How clever you are. :smileyvery-happy:

 

As the SQL Server database is on-premise data source, the gateway is required. As you use DirectQuery mode, on-premise data gateway is necessary. See: Live connections and DirectQuery to on-premises data sources.

 

Data source Live/DirectQuery User configured manual or scheduled refresh Gateway required
Analysis Services Tabular Yes Yes Yes
Analysis Services Multidimensional Yes Yes Yes
SQL Server Yes Yes Yes
SAP HANA Yes Yes Yes
Oracle Yes Yes Yes
Teradata Yes Yes Yes

 

Best Regards,
Qiuyun Yu

ross_lambert's avatar
ross_lambert
Regular Visitor
8 years ago

Hi mak82pk,

 

Our company has a product that allows you to use DirectQuery mode in a hybrid environment without using the Data Gateway. Since you have to poke a hole in the firewall for the Data Gateway, anyway, we just skip the Data Gateway and go straight to our product instance in the cloud.

The product is called Conduit and it was created specifically to allow direct query connections on all connectors, as well as create connectors for some data sources Power BI doesn't support (e.g. ElasticSearch 6).

 

Ping me if you have more questions.

 

Thanks,

 

== Ross ==

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi All,

     

    I am trying to connect Power BI with IBM DB2 for Direct Query. The required driver has been installed but it still cannot connect to IBM DB2 server. When I tried to connect with Microsoft .Net Framework, it couldn't connect as well. I checked in the command prompt, and it shows .net framework 4.8 is being installed wherein, 4.5 or higher verison is required. Can anyone please help me on this?

    Connection parametersConnection error is Power BI gateway. Same error comes through get data source as well

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Guys, 

      Any updates on this?