Connect Power BI to a database (DirectQuery) with SQL INDEX

[Anonymous]

Hello everyone,

I am working with Power BI Desktop and I want to connect it to a database with DirectQuery.

I have a simple question :

How to connect my PBIX to my database using SQL index tables ? 

Thank you.

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

Hope these posts could help you:

Power BI and SQL Server Indexes;

Improve Power BI Performance with SQL Server Indexing.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if it information schema table. A user has access to the table. it should be shown in the list , I assume.