cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Asingh01
New Member

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

Hi,


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.


Thanks!

1 REPLY 1
Fowmy
Super User IV
Super User IV

@Asingh01 

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:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-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

Announcements
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!

secondImage

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.