The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 create index on the tables?
P.S. I'm using non clustered column store index on all my tables
Thanks,
Oded Dror
Solved! Go to Solution.
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
Jimmy,
Thank you for the explanation, my question was should I create an index in SQL Server or not?
Is Power BI its own machanism to handle that?
Thanks
@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
Thank you (I have difficulty to mak your answer - I'm getting authentication issue when I submit)
Oded Dror
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |