model.get_table(table_name) ValueError: Neither dictionary nor hidx found for column

[some1ataplace]

table_name = 'YourTableName'
table_contents = model.get_table(table_name)
print(table_contents)

vertipaq_decoder.py line 182 in _get_column_data
raise ValueError(f"Neither dictionary nor hidx found for column {column_metadata['ColumnName']} in table.")

It works for some tables, but the data source I am connected to is a data analysis service cube which is a SQL Server View behind the scenes. It could be that the amount of data in the table is larger than what can be handled by PBIXRay.

[Hugoberry]

I'm sorry, but this library deals only with imported models with data stored in the pbix file. What you are describing is a live connection, so there is no way of retrieving that without an xmla connection to SSAS.

[some1ataplace]

Makes sense. You described exactly what I am using. Maybe you can add some arguments to the get_table() function to specify the data source or xmla endpoint and maybe the credentials? If not, no worries. I do not necessarily need the get_table() function for my use case. This would be a nice to have feature.

[Hugoberry]

Cna confirm that I can replicate the error with Adventure Works, Internet Sales.pbix table Internet Sales