Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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.