Forum Discussion

SAG1's avatar
SAG1
Icon for Helper I rankHelper I
9 years ago
Solved

Better way to load dataset

Hello    I am very new to power Bi , and exploring ideas on my own . I need to do analytic report for Auto industry , my table has millions of records (think about auto sale in entire US for any p...
  • Anonymous's avatar
    Anonymous
    9 years ago

    The answer is a solid "Maybe".  This is going to completely depend on what is contained in your data.  If you are getting your data from an SQL database, you are advised to set up a data View to limit the data to whatever is required.

     

    I would certainly simply consider that you want to strip out any data that you don't need.  Remove columns you don't want.  Remove rows before a certain reportable date if required.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Yeah you can think of it like that.

     

    Power BI does have the ability to directly query a database as well, but i tend to avoid it where possible.