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.
Hi,
If have a large dataset and want to limit the dataset to those rows interested in based on user input rather than bring everything in and then filter afterwards which would in any case exceed the 1gb file size limit in power bi pro.
e.g rather than import all calendar years - import just calendar data for year = year input by user
then import the sales data for that calendar year.
How can this best be achieved in power bi?
Thanks
See if this YouTube video on Direct Query helps... I also pulled some notes from the Microsoft Docs below...
https://www.youtube.com/watch?v=usWa892e4Gc
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
There are a few benefits to using DirectQuery:
Proud to give back to the community!
Thank You!
Thanks for suggestion - in our case the underlying queries would take way more than 30 secs thus direct query not practical for us in this case - we wish for the data to be imported in quiet hours.
Any other thoughts parameterised datasets based on user input with import mode?
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |