Hidden table from SSAS Live connect visible in Power BI

[Anonymous]

Hi There, 

Recently, I tried connecting one of the Tabular models deployed in the on-prem SQL SSAS server. 

I have about 15 Dims and facts altogether.  I wanted to keep only 5 tables visible in the model and hence I selected other tables and hide them from the client tool and redeployed them. 

Now When I connect this tabular model in power bi, I still have all the tables although they are hidden. 

I tried connecting this model from excel and I only see the tables which were not hidden at the time of deployment. so it is working fine in excel. 

To test out further, I tried connecting this model in the tabular editor too and I can see few tables are hidden there too. 

I am not sure why do I see hidden tables from the tabular model in the Power BI desktop when I connect it using a live query.

Any clues?  

[Syndicate_Admin]

Hi @skygold16 ,

Could not reproduce it in my side as far as my test. When I create 3 tables in the tabular and hide 2 of them, after I deploy and bulid this tabular, it works fine in Power BI Desktop.

Please try to re-build the tabular model after deploying it, clear permissions in Power BI and re-connect to the tabular model to check.

You can also try to update Power BI Desktop version to 2.97.921.0 64-bit (September 2021) to check.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl]

Hi @Anonymous ,

Could not reproduce it in my side as far as my test. When I create 3 tables in the tabular and hide 2 of them, after I deploy and bulid this tabular, it works fine in Power BI Desktop.

Please try to re-build the tabular model after deploying it, clear permissions in Power BI and re-connect to the tabular model to check.

You can also try to update Power BI Desktop version to 2.97.921.0 64-bit (September 2021) to check.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.