Forum Discussion

shaht's avatar
shaht
Icon for Helper I rankHelper I
4 years ago
Solved

PowerBi DirectQuery + SQL Data Connection Issue

I am  working on a Live Dashboard using DirectQuery in PowerBI. I am using datasource from SQL Server which updates every 15 minutes.   The dashboard is working fine on my PowerBi Desktop, but on ...
Need Help
  • shaht's avatar
    shaht
    4 years ago

    v-janeyg-msft It is solved now. The encryption was to be enabled on the SQL Server side – As our server is internal-only we hadn’t enabled encryption on the connection.  

     

shaht's avatar
shaht
Icon for Helper I rankHelper I
4 years ago

Hi, I have a databse in SQL which updates every 15 minutes. I used DirectQuery to get live data for current day and publish it on PBI Service. For Direct Query, the update can be scheduled for 15 minutes. The standard refresh that you mentoned is for Import option I beliive.