Forum Discussion
PowerBi DirectQuery + SQL Data Connection Issue
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.
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
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.
Hi, shaht
If everything is normal in the service, Check for permission restrictions in SQL and RLS.
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Janey
Janey
Hi Janey, We tried this morning using different SQL credential vis Basic Method with no restrictions but it did not help. Is it compulsory to use Windows credentials which would match across desktop login, desktop data source setting, oiwer bi service login, and gateway data source settings ?
Hi, shaht
The account you log in to powerbi has nothing to do with the credentials of your data source. You need to consider whether there are permission restrictions on the data source, and whether you can view the data source by entering the credentials of the data source in powerbi.
Also, are you sure you are in DQ mode not LC(ssas)? If it is LC mode, the map data source is required.
Janey