Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Indexing on SQL Server

Hi there,   Do I need to create index on SQL server database tables when I pull data into power BI desktop? Or Power BI will handle that. What abount direct query against sql server do I need to ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Jimmy,

     

    Thank you

     

    Ed Dror

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous,

 

Thank you for the explanation, my question was should I create an index in SQL Server or not?

 

 

That's based on your requirement. For example, if you need to achieve some result in some measures based off the relationships between up and down rows, you can create an index column.

 

Is Power BI its own machanism to handle that?

 

Yes, like SQL script in SQL Server, you can also wirte Power Query or DAX function to use the index column.

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you (I have difficulty to mak your answer - I'm getting authentication issue when I submit)

 

Oded Dror

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi odeddror,

     

    This may caused by your power bi forumn authentication is expired, you may refresh the browser several times to solve this issue.

     

    Regards,

    Jimmy Tao