Hi, I have created a dashboard where in i select the Direct Query mode in conection settings. I see the data and charts correctly when i open the ..pbix file in my powerbi desktop. Once i publish this report, the next time it does not refresh even though i have entered the SQL Credentials in the dataset.
I have a setup where in SQL DB is populated on daily basis. After publishing the powerbi report when using direct query, the report dosent get refreshed next day. I try to manually refresh also but nothing happens. I have to open the report in powerbi desktop, do a refresh there and then publish again. How to make the data set getting refreshed when using the Direct Query mode.
I understand that Direct Query creates a live connection to data source.
In my case, the sql table is getting data filled once everyday. So everyday, the tiles and charts created whith the dataset which used Direct Query should be updated. Am i correct? For me this thing is not happening.
Is that your connection to the source is correctly configured. For data sources other than Azure SQL Database or Azure SQL Data Warehouse that use DirectQuery, and Enterprise Gateway must be installed and the data source must be registered to establish a data connection.
Thanks & Regards, Bhavesh
Love the Self Service BI. Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
I have the same issue. I am have created report in Power BI desktop and then published the report. My data source is on-premise SQL Server and uses Direct Query. If I make changes to the data it should refresh the published report, but it doesn't do that. Instead of refreshing the report on its own, I have to click refresh now on the ribbon of report. Is there way to configure the refresh time on Power BI Service or any other way around?
I was having the same issue, myself. I found the issue was that I had capitals in the SQL server name configured on the gateway, but I was lazy and didnt capitalize it when configuring the connection in the PBI Desktop report. Those server names need to be exactly the same in both.