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

Download/Edit PBIX from report server is original version

Not sure if this changed in the March release or if it's always been this way (or if i'm just crazy).  I have a lot of PBIX reports that are all set to auto-refresh on a schedule (daily) and it works great when hitting the PBIRS web server and looking at the reports.  However, the "download" and "edit in power bi" buttons load the original version of the PBIX file, which has none of the data that has changed in the weeks since it was uploaded.

 

Practically, this means any time you download the file, it won't look like the online version you just pulled it from.  For me, it means i have to hit a desktop PBI refresh button and go get coffee any time i want to download a pbix file and work with it, so it has the same data as the online version, but this seems like something that wasn't an issue in the past.

 

Is this a bug?  A normal behavior that i missed previously?

1 ACCEPTED SOLUTION

Accepted Solutions
Jon-Heide Established Member
Established Member

Re: Download/Edit PBIX from report server is original version

You're not missing anything, it's expected behavior for now.  Do up-vote it on PowerBI user voice. 

 

Just purely for background, when PowerBI report is uploaded, the underlying model is pulled out of the file and mounted on an internal instance of analysis services and stored seprately. The "re-stiching" of the model and report back into a single file is tricky and not currently supported. 

 

View solution in original post

7 REPLIES 7
Jon-Heide Established Member
Established Member

Re: Download/Edit PBIX from report server is original version

You're not missing anything, it's expected behavior for now.  Do up-vote it on PowerBI user voice. 

 

Just purely for background, when PowerBI report is uploaded, the underlying model is pulled out of the file and mounted on an internal instance of analysis services and stored seprately. The "re-stiching" of the model and report back into a single file is tricky and not currently supported. 

 

View solution in original post

narendra534 Frequent Visitor
Frequent Visitor

Re: Download/Edit PBIX from report server is original version

Hi Kraius,

 

Can you please let me know the option on how to schedule the auto refresh option once the reports are published on the reporting server. Also looking for setting an email subcription to the report baswcially a screenshot to email after the scheduled refresh is completed.

Kraius Frequent Visitor
Frequent Visitor

Re: Download/Edit PBIX from report server is original version

No idea on the subscription part of the question as we never really played with it.  You can schedule refreshes of reports in the web GUI.  click the three dots in the corner of the report tile and go down to manage.  it will have both "data sources" and "scheduled refresh" sections that you'll need to configure to set it up to refresh 

JesusDB Frequent Visitor
Frequent Visitor

Re: Download/Edit PBIX from report server is original version

I have been downloading the pbix files from the Report Server at the beginning of the month to have a copy of the reports each month. And, now I have realized that the data weren´t of the download date. This behavior is not logical, is very confusing!

Is there any issue in https://ideas.powerbi.com to ask for changing that behavior?

Thanks

Kraius Frequent Visitor
Frequent Visitor

Re: Download/Edit PBIX from report server is original version

If you just want the modeled data out of the pbix file every month, you might be better off exporting it via a script.  Something like the below PBI_Exporter.ps1 would probably work well:

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-us...

 

That way you can easily pull that exported monthly snapshot back into a PBI report if needed (it's just a CSV/XLS dump of the non-measure data in the model).  There might be newer/better ways to do this now (if your using the cloud service), but i think you're limited to options like this if using on-prem (report server) or local desktop solutions

JesusDB Frequent Visitor
Frequent Visitor

Re: Download/Edit PBIX from report server is original version

Thanks Kraius for your message.

- - 

(When I need download intensively pbix with data updated I´ll test this solution:

https://github.com/microsoft/ReportingServicesTools/blob/master/ReportingServicesTools/ReportingServ...

)

cronalfman New Member
New Member

Re: Download/Edit PBIX from report server is original version

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 Kudoed Authors (Last 30 Days)
Users online (2,123)