Publish without applying changes on the Desktop

[Anonymous]

Hi,

I have developed a dataset that pulls in lots of files from our OneDrive and it takes forever to update from the desktop.

So I am wondering -- If i make changes to the desktop Query and then save the file without applying the changes and then Publish the file and do a refresh on the web do the new changes get applied on the web version of the dataset?

Regards

Andrew

[v-danhe-msft]

Hi @Anonymous,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[zlokesh]

Hi @Anonymous,

                  Please go through the below screen shot you will get Idea.

Save is Necessary then only we can publish report.  (When you press Publish button , it pop-ups the message box to save)

Accept solution if you are satisfied, else let me know so that can help more. Thanks

Need To Save before Publish report

[masplin]

I have exact same issue. The server on which i have to run the desktop is not powerful enoguh to refrsh the query so i can't apply it in desktop. i tried as you did to save anyway and publish but sadly the servie only refreshes the query that were successfully applied. 

seems a major limitation and the servie is much more efficient at refreshing datasets than the desktop on alocal machine.

I have no idea how to proceed now. Did you find any solution?

Mike

[Anonymous]

Hi,

My workaround was to use a parameter to reduce the amount of data i was processing for the desktop and then change the parameter once uploaded to the cloud.

[masplin]

Ah thats a god idea. So say you have a start date in a seperate table and you set it short to upload the fact table. Thenyou change the start date to be al lthe data and just update that table and then publish?

Mike

[v-danhe-msft]

Hi @Anonymous,

Based on my test, you could not get the new changes without applying the changes in query editor.

1.I have replace the value “Germany” to “test one” without applying changes and published the pbix file to the service.

2.I refreshed the dataset and the value of the “Germany” is still shown as the original value like the picture.

Regards,

Daniel He