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.  

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Something doesn't quite compute. You say you are connecting via direct query yet you have set a refresh schedule. Please explain what made you choose that.

 

Also, how can you schedule refreshes every 15 minutes?  The standard refresh request slots are top and bottom of the hour.