The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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?
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |