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

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
Anonymous
Not applicable

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 @Anonymous ,

 

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

 

Looking forward to your feedback.


Best Regards,
Henry

Anonymous
Not applicable

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