Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hidden table from SSAS Live connect visible in Power BI

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?  

Need Help

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

     

     

     

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    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.

    vyingjl_0-1633069562855.pngvyingjl_1-1633069575327.png

    vyingjl_2-1633069596471.png

     

    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.