Skip to main content

Power BI

New

Limit data load until publishing

Vote (8) Share
Alex Dantin's profile image

Alex Dantin on 15 Nov 2016 04:40:53

In working with large data sets, it takes a long time to set up the queries and then apply them to the model, just to do some testing or basic report construction. While it is possible to filter the query to limit the data loaded in, when it comes time to publish, I have to go back to the query, remove my filter, then apply the change. I would like to see some kind of smart filter applied that can be ignored when the report is published so that I don't have to wait every time I need to make a change with something.

Comments (2)
Alex Dantin's profile image Profile Picture

6e8592d8 0ed6-4dc1-bc8d-3c6abf353dee on 05 Jul 2020 23:34:52

RE: Limit data load until publishing

My workaround is to incorporate a parameter into the query that can filter the data. After publishing the report, I log into the web interface and update the parameter to unfilter the data and refresh the data set.

Alex Dantin's profile image Profile Picture

c3cb1933 de2d-47f3-8aa0-d0a2821c5faf on 05 Jul 2020 23:18:30

RE: Limit data load until publishing

At present with any change made you are forced to refresh data before you publish otherwise the changes will not be published. This can be very time consuming and resource intensive for large queries particularly as they end up running twice - once locally and again after the report is published. It is particularly frustrating when running on a low spec PC (e.g. tablet).

Please allow for query changes to be published without having to refresh data first.