Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to control how much data is being pulled into Power BI from a SAP BW query? For instance, our system has data available from 2012 to current. I only need to pull in 2016-2017 data. I would like to be able to control the date range in the connection process so that the download is much quicker. It is currently waisting time pulling in 2012-15 data I do not want and have to filter out of my results.
Solved! Go to Solution.
Hi @Anonymous,
by filtering the data this way will it speed up the process of refreshing the data from BW?
Yes, it will speed up the process of refreshing by filtering the data from BW this way(instead of loading the entire set of rows into the Power BI Desktop data model).
Regards
This might not answer your specific question, but you should take a look at the Simplement Data Liberator.
This platform surfaces SAP tables effortlessly and in real-time. You can define exactly what you want to bring over. It places all these tables directly into SQL Server, ready for Power BI.
Mike McNally
mmcnally@simplement.us
Hi @Anonymous,
In this scenario, you can filter on your date column in Query Editor to specify a set of rows which you want to be finally brought into the Power BI Desktop data model.
Select the date column you want to filter on.
Click the down arrow ( ).
Regards
I saw that option....by filtering the data this way will it speed up the process of refreshing the data from BW?
Hi @Anonymous,
by filtering the data this way will it speed up the process of refreshing the data from BW?
Yes, it will speed up the process of refreshing by filtering the data from BW this way(instead of loading the entire set of rows into the Power BI Desktop data model).
Regards
Thx for your feedback...much appreciated!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |