Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

How to reduce the time for loading a data from SQL server.

Hi All,   I am here again with a most common and pathetic issue in Power BI, In my case i almost find my self sleepy while i tried to load any table from my SQL server which is having rows in Lakh...
Need Help
Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

Anonymous

 

 no buddy said that i am bounded with certain condition.

 

Regards 

Satish

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Satish_Kumar

 

  DAX is your best friend then.

 

Regards

  • Satish_Kumar's avatar
    Satish_Kumar
    Icon for Helper V rankHelper V
    9 years ago

    Anonymous

     

    How DAX help me in importing the data.

    Please will giude me a little.

     

    Regards,

    Satish

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    DAX Won't help you in importing. It will certainly help you in filtering the data as per your will. You can refer to this link for further details on filtering of data using DAX.

     

    https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

     

    Regards