Getting additional columns in Power bi report without refreshing complete data.

[ParulSingh]

I want to get new columns into Power BI Report but don't want the data to refresh completely as the data is huge making it heavy. Is there a way to  apart from applying a filter on desktop and removing it on service?

[ParulSingh]

Hi @AnushaSri ,

Thanks for your response!
The solution helps for checking the data in desktop version but we want to ultimately be able to refresh the report on Service, which is not happening using this option.

[AnushaSri · Accepted solution]

Hi ,

Check this video, it might help you as this explaining how to add a Measure or columns to model setup with incremental refresh without needing of refreshing the entire model.

https://youtu.be/s0j6d3UAw9U?si=LbDUfVCibAzM2ER-

[AnushaSri]

Hi ParulSingh,

In Power Query, you can untick Include in report refresh, but tick enable load, would probably load the data without do a refresh.

Please mark this as solution and give Kudos, if this helps resolve your issue.