cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
varunsingh Frequent Visitor
Frequent Visitor

Refreshing Dataset when using Direct Query

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. 

 

Thanks in advance.
Varun

8 REPLIES 8
BhaveshPatel Super Contributor
Super Contributor

Re: Refreshing Dataset when using Direct Query

You should understand what direct query is? It means live connection to your data and you do not need to refresh the dataset as you are connecting live to your data set.

 

Refer more on this at 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

 

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.
varunsingh Frequent Visitor
Frequent Visitor

Re: Refreshing Dataset when using Direct Query

Thanks for the reply Bhavesh.

 

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.

 

Thanks,

Varun

BhaveshPatel Super Contributor
Super Contributor

Re: Refreshing Dataset when using Direct Query

 

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.
Microsoft v-micsh-msft
Microsoft

Re: Refreshing Dataset when using Direct Query

Hi varunsingh,

 

Agree with @BhaveshPatel here. Using Direct Query with On-premises data sources, there is no need to configure Schedule refresh.

Read more about this under the Live connections and DirectQuery to on-premises data sources part in the article below:

Data refresh in Power BI

Please check the dataSet by right click in Power BI service, there should be information marked that this is a live connection.

Check the data source settings, make sure it is well configured.

If issue insists, then please post back.

Regards

 

reachsamit Frequent Visitor
Frequent Visitor

Re: Refreshing Dataset when using Direct Query

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?

omasutani Frequent Visitor
Frequent Visitor

Re: Refreshing Dataset when using Direct Query

Hi, I am in same situation, I have never seen the Power BI reports refreshed via DirectQuery on Services.

I am using Azure SQL Server which you told it doesn't need Gateway.

I have separate IDs between PowerBI Pro and Azure, is it affect it ?

Samaneh78 Frequent Visitor
Frequent Visitor

Re: Refreshing Dataset when using Direct Query

I too have the same issue.

 

I´m using Power Bi Desktop and connecting to an On Premiss SQL Database

 

After I created my report in PBI Desktop I then published it to the PBI cloud and created an On premiss Gateway in the PBI cloud.

 

Now I really would like to know how to get the dashboard to auto-refresh whenever the source database gets an update.

Re: Refreshing Dataset when using Direct Query

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.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors