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

To Accompanish this automated 15 minute update, if you have anyother option then please let me know. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, shaht 

     

    Has the refresh history failed? Have you ruled out the three possibilities suggested by the error message? Can other people in the organization see the report? Has it been displayed normally in the service before? Did the problem suddenly occur? Does the report have only sql data source?

    Check if there will be RLS on the SQL side, Is the gateway up-to-date and functional?

    If everything is ok, try to re-publish the pbix file to the service.

     

    Janey

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

      The refresh history is fine as I showd in one of the image. No other people also can not see tis reports. This is the first time we are using Power BI in our organisation. Gateway is working fine on personal mode with local excel files but with SQL is shwoing this issue. Yes report has only 1 datasource from SQL. Gateway is latest version.