changing SQL query once pbix loaded to the service

[Parosel]

I've loaded a file to the service with the data restricted by the original SQL query importing the data into the PBIX file. I did this because when I ran the whole dataset it has repeatedly failed with a connection termination error at the server side on SQL.

Now that I have sucessfully loaded the data into a dataset in my service is there a way I can now change the original SQL statement to remove the where clause filter and so refresh the full dataset in the cloud?

[lbendlin · Accepted solution]

You can use a Parameter to hold the query text. That parameter can then be changed in the dataset's settings in the workspace.

Alternatively you can consider using incremental refresh, worst case with partition bootstrapping.