Forum Discussion

AllanXu's avatar
AllanXu
Icon for Helper II rankHelper II
9 years ago
Solved

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 th...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

     

    AllanXu

     

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

 

AllanXu

 

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,

  • Sunkari's avatar
    Sunkari
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    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.