Through DAX Studio using DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES)

sandypigili0724 — Thu, 22 Jun 2023 03:40:41 GMT

Using this DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES) I am Getting Rows_Count.

But in that Rows_COUNT for column values it is adding 3 extra values for every column.

For Example i have a table called Test ,in that i have column A and Column B.

Basically Column A has 3 values but it is showing value as 6.

I need help on this aspect

Re: Through DAX Studio using DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES)

Anonymous — Tue, 27 Jun 2023 02:56:20 GMT

HI @sandypigili0724,

What version Dax studio are you used? Did this issue appear again if you change to use other methods to connect to power bi data mode with the same queries? Please share some more detail information to help us clarify and troubleshoot on it:

How to Get Your Question Answered Quickly

In addition, since this is a third party tools, you can also try to contact to the dev team to confirm this scenario:

Issues · DaxStudio/DaxStudio · GitHub

Regards,

Xiaoxin SHeng

topic Re: Through DAX Studio using DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES) in Developer

Through DAX Studio using DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES)

Re: Through DAX Studio using DMVs( select * from $SYSTEM.DISCOVER_STORAGE_TABLES)