Hugoberry
model.get_table(table_name) ValueError: Neither dictionary nor hidx found for column
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.
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.
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.
Cna confirm that I can replicate the error with Adventure Works, Internet Sales.pbix table Internet Sales