Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Composite Model (Import/DQ) - refresh time not displaying in the service

When a report based on an import model is published to the service, with new look on, it displays the last refresh time in the header, top-centre of the report page, along side the Title and Contacts.

 

Changing this to be a composite model with Direct Query (DQ) connection(s) appears to make this last refresh time disappear from the report page header.

 

I assume as some of the data in the report is queried when a user interacts, and some is on a scheduled refresh import, the last refresh time is not displayed as it would not represent both scenarios.

 

Is this correct? If so, is there better solution that creating the last refresh data using Power Query - this is non-ideal as it requires real estate on the report page to display.

 

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

 

Thanks

 

@mahoneypat
@camargos88
@harshnathani
@AllisonKennedy
@FrankAT
@DebbieE
@BA_Pete
@DataZoe
@EricHulshof
@Daviejoe
@DavidWaters100
@fhill
@kcantor
@Pragati11
@ryan_mayu
@ashishrj
@jthomson
@dedelman_clng
@lbendlin
@vivran22
@AntrikshSharma
@mussaenda
@OwenAuger
@nandukrishnavs

8 REPLIES 8
AllisonKennedy
Super User
Super User

@Anonymous Using the Power Query method for last refresh time, you could add a small icon/button to the report page and place a tooltip on that so that last refresh time takes up less space than needed to display the entire last refresh time if you were to use a card or table visual. Does that help/make sense?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons#set-button-properties-when-idle-hovered-over-or-selected

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

Thanks Alison, tooltips definitely seems like a good way to go with this realestate limitation - i'll definitely give that go as well as Greg's tooltip suggestion

 

That coupled with BA_Petes suggestion of just the PQ datetime.FixedLocalNow as a query to avoid whole columns is great; my understanding Pete is that I will import this query and it will represent the import time of the other tables, the DQ data being as current as the last user interaction with the DQ data, so I will not display a refresh time for this.

 

Cheers all!

@Anonymous ,

 

I think you understand correctly. The DateTime.FixedLocalNow() query will refresh along with all your other imported queries when you perform a refresh on the dataset in the PBI Service, giving you a pretty good steer on last imported model DateTime. The 'Fixed' part just prevents it from changing during successive calls during execution of an expression.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




BA_Pete
Super User
Super User

Hi @Anonymous ,

 

The link you provided is essentially the way that I have displayed last refresh time in reports in the past except that I don't add an entire column into a table for it, I just create a blank query and add the following into the formula bar:

= DateTime.FixedLocalNow()

This can then be used as a field on your report (adjusted for the time zone etc. that you want it to display).

How this would behave in an Import/DirectQuery hybrid model, I have no idea I'm afraid.

 

Pete 



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Greg_Deckler
Super User
Super User

>sigh< I feel left out.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler please do not be offended 😛

 

any help is appreciated!

 

 

@Anonymous - I was just joking! Hopefully someone else jumps in here because I do not know of any way around that issue. What you describe is my understanding of how things work and creating your time stamp is the only way I would know how to fix it. If you did not want it to take up space, you could add it to the Tooltips area of your visuals perhaps.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

The tooltip is a good suggestion and something I had not considered - cheers Greg!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors