The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
First I Connect to the server and open the database that contains the model using the Server and Database classes in Microsoft.AnalysisServices.Tabular namespace.
Now I have used pythonCopy code in Visual Studio Code
import clr
clr.AddReference('Microsoft.AnalysisServices.Tabular')
from Microsoft.AnalysisServices.Tabular import Server, Database
server_name = "localhost\\tabular"
database_name = "AdventureWorks"
server = Server()
server.Connect(server_name)
database = server.Databases.GetByName(database_name)
Note :- After Run the Code I was found error
Thi ( clr.AddReference("Microsoft.AnalysisServices.Tabular")
AttributeError: module 'clr' has no attribute 'AddReference' )
Please solution this error I have mentioned the error in red color text