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

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
Highlighted
Super User IV
Super User IV

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

>sigh< I feel left out.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

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

@Greg_Deckler please do not be offended 😛

 

any help is appreciated!

 

 

Highlighted
Super User IV
Super User IV

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

@guyatadesk - 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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User I
Super User I

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

Hi @guyatadesk ,

 

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 

Highlighted
Super User II
Super User II

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

@guyatadesk 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-...

 


______________


Has this post solved your problem? Please mark it as a 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.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

Highlighted
Frequent Visitor

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

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

Highlighted
Frequent Visitor

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

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!

Highlighted
Super User I
Super User I

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

@guyatadesk ,

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors