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

Tile value is updating in desktop but not in web version

Hi,

 

We have connected to the PowerBI Rest API to get meta data around our Power BI datasets, e.g. count of failed refreshes etc.

 

Let's call it our 'Power BI Admin Report'.

 

Further we've installed a personal gateway on the machine where the report was published. 

 

What's working: All values in the report Power BI Desktop are displayed correctly when the refresh happens on the machine.

What's not working: 1 single tile value does not refresh once the report is viewed in the Power BI web version.

This tile value is based on a column with the calculation:

IF(DATEDIFF('Refresh History (2)'[End Time Local],'Refresh History (2)'[Today],MINUTE)<60 && 'Refresh History (2)'[Status]="Failed",1,0)
 
Any suggestion why this tile value is not updating in the web version, but in the desktop version?

Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Daniel15889 Frequent Visitor
Frequent Visitor

Re: Tile value is updating in desktop but not in web version

We fixed it ourselves.

 

What was the issue: The calculation of UTC-5 to get ET worked in Power BI desktop, but not in Power BI web service.

 

How did we resolved it: We simply took out the calculation and found a workaround to not have to use ET.

 

Thanks

Daniel

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Tile value is updating in desktop but not in web version

Hi @Daniel15889 

 

Do you mean all the other visuals updated after refresh but only the special one failed? Could you please confirm you enabled the  " Include in report refresh" option on the table?

Would you mind sharing your dummy pbix that I check it further?

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Daniel15889 Frequent Visitor
Frequent Visitor

Re: Tile value is updating in desktop but not in web version

We fixed it ourselves.

 

What was the issue: The calculation of UTC-5 to get ET worked in Power BI desktop, but not in Power BI web service.

 

How did we resolved it: We simply took out the calculation and found a workaround to not have to use ET.

 

Thanks

Daniel

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,936)