cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wing_hk
Helper I
Helper I

Report Portal Visuals updated after schedule refresh but can only download old pbix

Hi all,

 

I can't find similar problems in this PBIRS section so here below is my situation:

 

PBIRS: 15.0.1106.169 (On premise)

Edition: Power BI Report Server - Developer (Dev environment)

PowerBI client: May 2020

Server mode: Native

 

For example

(1) Upload new report to PowerBI web portal at 2pm and setup scheduled refresh at 2:15

(2) After 2:15 Web UI showing "Completed Data Refresh" in "Manage" page and no failed msg in server log

(3) Checked on web portal data in report are showing new data

Update time card visual in report showing 2:15 

"Modified date" of file in web portal: still 2:00

(4) When choosing "... ->download" from report list, the pbix version are still the 2:00 version

(5) Same when choosing "Edit in PowerBI Desktop"

 

Q1: 

It's not the "can't overwrite" issue posted before as it's a new report. Also the visual on web portal are actually updated.

Should I stop/start PBIRS to get the updated PBIX file?

 

Q2:

I noticed that in "ExecutionLog3" the "Request Type" is "Refresh Cache".

Is the "Scheduled Refresh" actually refreshing the cache and won't update file? So my problem is just as expected

 

Our scenario is to generate differnt reports depends on different data source login.

We copy same report to different location and update login info with script.

And user should be able to download different reports after scheduled refresh.

That's why we need to get the refreshed file.

 

ExecutionLog3:

 

RequestType Format Parameters ItemAction TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount AdditionalInfo
Refresh Cache DataModel NULL SaveToCatalog 2022-01-13 10:56:32.770 2022-01-13 10:56:33.930 0 0 0 Live rsSuccess 3670016 0 NULL
Refresh Cache DataModel NULL DataRefresh 2022-01-13 10:56:02.637 2022-01-13 10:56:32.453 816 0 0 Live rsSuccess 0 0 NULL
Refresh Cache DataModel NULL ASModelStream 2022-01-13 10:56:01.897 2022-01-13 10:56:02.633 0 0 0 Live rsSuccess 0 0 NULL

 

RSPowerBI log on Server

 

Line 44028: 2022-01-13 10:56:01.8055|INFO|180|Handling event with data: TimeEntered: 1/13/2022 2:56:00 AM, Type: Event, SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, EventType: DataModelRefresh
Line 44029: 2022-01-13 10:56:01.8055|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Data Refresh.
Line 44030: 2022-01-13 10:56:01.8055|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Retrieving PBIX AsDatabaseInfo.
Line 44032: 2022-01-13 10:56:01.8825|TRACE|132|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Retrieving PBIX AsDatabaseInfo.
Line 44033: 2022-01-13 10:56:01.8825|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Verifying all the data sources are embedded.
Line 44034: 2022-01-13 10:56:01.8825|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Verifying all the data sources are embedded.
Line 44035: 2022-01-13 10:56:01.8825|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Verifying connection strings are valid.
Line 44036: 2022-01-13 10:56:01.8825|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Verifying connection strings are valid.
Line 44037: 2022-01-13 10:56:01.8825|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Streaming model to Analysis Server.
Line 44038: 2022-01-13 10:56:01.9625|TRACE|5|New clientSessionId generated: clientSessionId=5272039a-3bba-45d7-b4cf-c7cfae7b6aae
Line 44039: 2022-01-13 10:56:02.0624|INFO|5|LoadDatabaseAsync: Successfully EnsureDbLoaded clientSessionId=5272039a-3bba-45d7-b4cf-c7cfae7b6aae, databaseName=3bb82aef-0949-44fe-aa78-eba01bc5df51_1646991856, modelId=1071789668, alreadyLoaded=True
Line 44040: 2022-01-13 10:56:02.6352|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Streaming model to Analysis Server.
Line 44041: 2022-01-13 10:56:02.6352|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Refreshing the model.
Line 45142: 2022-01-13 10:56:32.4502|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Refreshing the model.
Line 45143: 2022-01-13 10:56:32.4502|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Removing credentials from the model.
Line 45144: 2022-01-13 10:56:32.7691|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Removing credentials from the model.
Line 45145: 2022-01-13 10:56:32.7691|INFO|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Starting Saving model to the catalog.
Line 45146: 2022-01-13 10:56:33.9307|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Saving model to the catalog.
Line 45147: 2022-01-13 10:56:33.9307|TRACE|180|Processing Data Model Refresh: SessionId: 5272039a-3bba-45d7-b4cf-c7cfae7b6aae, Status: Finished Data Refresh.

 

1 ACCEPTED SOLUTION

Thanks for following up. This post was blocked as spam before but released now.

 

My question has been answered in another post that it's expected users can not download refreshed data.

Solved: Visual updated in scheduled refresh, PBIX still ol... - Microsoft Power BI Community

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @wing_hk ,

 

I can't seem to reproduce this question, where is the question going now?

 

Looking forward to your feedback.


Best Regards,
Henry

Thanks for following up. This post was blocked as spam before but released now.

 

My question has been answered in another post that it's expected users can not download refreshed data.

Solved: Visual updated in scheduled refresh, PBIX still ol... - Microsoft Power BI Community

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Kudoed Authors