cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Direct Query Dataset and Report do not match?

Have a dataset that is DirectQuery to a SQLServer database/table.

 

Have a report built on that dataset.

 

When I manually refresh the dataset, then check the report - the two do not match (sometimes they will, sometimes they don't).  Meaning: The report doesn't show the last few records that I can clearly see in the SQL table..

 

IF I do a manual refresh of dataset, build a quick table report on a new tab, the new table report shows the correct data...But the existing report doesn't -- each is based off the exact same table/field

 

Am I missing something?

 

Thanks,

Chas

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Direct Query Dataset and Report do not match?

@Chas2002 This largely depends on what you are doing. If you immediately check the report after you refresh the dataset it is highly likely you will need to manually refresh the report. This initiates a refresh from the dataset, otherwise it may still show the cached data.

The dataset, report, and dashboard are seperate elements. The normal process is that there is a cached dataset that is in place so the reports don't break during a refresh. An automated process runs (on some schedule) to refresh the report and dashboard after a dataset has been updated. The reason your new report works is because it is looking at the latest data you just pulled. The existing report has a cached set you need to manually update if you want instant results.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors