Showing results for 
Search instead for 
Did you mean: 
New Member

Filter Online Data source prior to connection to PBI Desktop (just like SQL connections)


We moved from on prem Business Central to Business Central Online and we used to run the SQL scripts on the PBI connector to only bring the data we want to report on. But for Cloud connector, its bringing the FULL data table and we have to then add power query filters on the full data set. This makes the dashboards very heavy and long loading time. Is there a way we can filter the data for online connectors just like SQL connectors? For example, only bring in data from 2020 and not the full table which can include data from decades ago.


Super User IV
Super User IV


When you filter in Power Query at the beginning step of the query, only limited data should be loaded. However, to avoid fetching the whole data, try Incremental Refresh:


If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn  

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.