Forum Discussion
Helper IPowerBi 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 PowerBI server, the Report is not being able to connect with the data source.
I have used On-Premise gateway and the data source is connected successfully and being refreshed every 15 minutes but the visual is not able to load the data.
I have attached photos of the error and the data source settings that I have on Desktop and on Gateway. Could you please have a look and advise where could be the connection issue occurring ?
successful data connection with refreshPBI desktop connectiongateway detailserror-1error-2
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.
28 Replies
- lbendlin
Super User
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.
shahtHi, 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.
- shaht
To Accompanish this automated 15 minute update, if you have anyother option then please let me know.
- v-janeyg-msft
Community Support
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
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.
