Forum Discussion
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 ...
Jimmy,
Thank you
Ed Dror
Hi odeddror,
If you connect to your sql server instance using import mode, you can add an additional index column in power query, click Query Editors-> Add Columns-> Index Column. If using direct query/live connection mode, you should create index column in your database because power bi doesn't allow users to create any custom columns in power query or calculate columns in DAX in direct query/live connection mode.
Regards,
Jimmy Tao
Jimmy,
Thank you
Ed Dror