Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AllanXu
Helper II
Helper II

SQL Server large tables: how to ask user for the data date range being imported into PBI?

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,

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

 

@AllanXu

 

In this scenario, you can use Query Parameter in your Power Query.

 

Just create two parameters StartDate and EndDate.

 

3.PNG

 

It will query/refresh data based on the current value in the parameters.

 

777.PNG

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Employee
Employee

 

@AllanXu

 

In this scenario, you can use Query Parameter in your Power Query.

 

Just create two parameters StartDate and EndDate.

 

3.PNG

 

It will query/refresh data based on the current value in the parameters.

 

777.PNG

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.