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

Can I made a model change and have the data not update?

My assumption is that this is not possible.

 

I'm running into an issue where I make a small change in the model, such as adding a new table and changing a parameter that causes multiple tables to require a refresh. 

 

Working remotely, this causes a problem as I am getting timeouts that do not occur when it refreshes on the premium workspace. I was hoping there was some way that I could make the changes, publish the model and allow the refresh to occur after it's uploaded. I could then either download the refreshed PBIX or refresh mine later and see if it's just the fact of the number of people using the backend databases.

 

Again, don't think it's possible, but if there is some magic out there, I'll take it.

 

Thanks in advance

 

1 ACCEPTED SOLUTION
Solution Sage
Solution Sage

for this kind of scenario where the PBIXs locally its kind of unmanagable for different reason theres a little trick you could try, in power query configure some parameters, use them to limit the data on the PBIX to its smallest expresion, one month, one category, etc something that reduce the file to just a few lines, do the changes you requier, upload to the workspace and put back the parameters to one that doesnt crunch out data and refresh on service as soon as uploaded. 

 

if this solved your question please give some kudos and mark as solution for others to find it. 

View solution in original post

2 REPLIES 2
Helper V
Helper V

I've done that already, I think there was some sort of heavy load going on at the server or a deadlock. 

 

I'm trying to see if, perhaps, I can use data flows or have one PBIX source from another PBIX....Ok, I know you can because this is the live connection source for my front ends, but I don't know how far I can chain it back and whether it would cause the upline source to requery.

Solution Sage
Solution Sage

for this kind of scenario where the PBIXs locally its kind of unmanagable for different reason theres a little trick you could try, in power query configure some parameters, use them to limit the data on the PBIX to its smallest expresion, one month, one category, etc something that reduce the file to just a few lines, do the changes you requier, upload to the workspace and put back the parameters to one that doesnt crunch out data and refresh on service as soon as uploaded. 

 

if this solved your question please give some kudos and mark as solution for others to find it. 

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors