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!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors