mds
2 TopicsDefault Super-User for Master Data Services
Hello, I have a question about the administrator account which must be specified during the setup of the MDS database with the "Create Database Wizard". -> "This account will be automatically granted full access to all models. You can configure only one account with this permission." My question is: Where is this account still used by default? We want to change the password of this admin account and I wonder if I need to enter or re-enter this new password somewhere? Thanks, Maik567Views0likes1CommentDMV request to Power BI Server Analysis Services for hidden tables in PowerQuery
I try to get the list of tables with M codes from PowerBI online Analysis Service. I managed to get the required data with the request: SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS But it doesn't show any tables that were selected not to "Load" in PowerQuery. The purpose of this task is to get all data connections from a dataset and hidden tables are essential. Does anyone know how to get the hidden tables' codes?Solved5.6KViews0likes8Comments