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.
Hello,
I have a very large SQL server table that I need to create a PBI report based on.
There is no way to import all of the table's data into PowerBI.
Each record has a date.
Is there any way to ask user the date range of the records when he refreshes data?
Thank you,
Solved! Go to Solution.
In this scenario, you can use Query Parameter in your Power Query.
Just create two parameters StartDate and EndDate.
It will query/refresh data based on the current value in the parameters.
Regards,
In this scenario, you can use Query Parameter in your Power Query.
Just create two parameters StartDate and EndDate.
It will query/refresh data based on the current value in the parameters.
Regards,
One option is query parameters.
Another one is creating partitions at database level and adding proper where condition in source query, which will improve the performance and restricts data at required time period.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |