cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shanka
Advocate II
Advocate II

Stop refreshing once imported

May be I'm asking for too much, but I'm trying to increase efficiency of my Power BI report and was wondering if this is possible...

 

I have imported 10 different SharePoint lists into my report. Based on a few common columns I have used "Append Query" feature to merge these lists into one.

 

Now, out of these 10 lists, 5 have been decommissioned. While I still need to show the existing data from them, is there anyway I can stop my Power BI seeking data during scheduled refreshes?

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

There is an option in the query editor "Include in Report Refresh", which by default is activated. If you deselect it, your query will not be refreshed when the report is refreshed - BUT ONLY if it loaded directly to the data model. This is not the case with your data, but you can use this workaround instad: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

1 REPLY 1
ImkeF
Super User
Super User

There is an option in the query editor "Include in Report Refresh", which by default is activated. If you deselect it, your query will not be refreshed when the report is refreshed - BUT ONLY if it loaded directly to the data model. This is not the case with your data, but you can use this workaround instad: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors