Here's some all-in-one python to get this working again for 2026 - though, I think GraphQL is a better option than XMLA at this point.

import os
import requests
import zipfile
import io

PACKAGE_NAME = "Microsoft.AnalysisServices.AdomdClient"
VERSION = "19.113.2"
DLL_NAME = "Microsoft.AnalysisServices.AdomdClient.dll"

def download_and_extract_latest():
    script_dir = os.getcwd()
    print(f"📦 Downloading {PACKAGE_NAME} v{VERSION}...")
    

    url = f"https://www.nuget.org/api/v2/package/{PACKAGE_NAME}/{VERSION}"
    r = requests.get(url, allow_redirects=True)
    
    if r.status_code == 200:
        with zipfile.ZipFile(io.BytesIO(r.content)) as z:

            dll_files = [n for n in z.namelist() if n.endswith(".dll") and "lib/" in n]
            
            for member in dll_files:
                filename = os.path.basename(member)
                target_path = os.path.join(script_dir, filename)
                
                with z.open(member) as source, open(target_path, "wb") as target:
                    target.write(source.read())
                print(f"   ✅ Extracted: {filename}")
                
        print(f"\n🚀 Done! {VERSION} files are now in: {script_dir}")
    else:
        print(f"❌ Failed to download. Status code: {r.status_code}")

if __name__ == "__main__":
    download_and_extract_latest()

import os
import requests
import zipfile
import io


LIBRARIES = {
    "MSAL": {
        "package": "Microsoft.Identity.Client",
        "version": "4.65.0", # Exact version from your error
        "dll": "Microsoft.Identity.Client.dll"
    },
    "Identity_Abstractions": {
        "package": "Microsoft.IdentityModel.Abstractions",
        "version": "8.0.0", # Foundation for modern MSAL
        "dll": "Microsoft.IdentityModel.Abstractions.dll"
    }
}

def download_dependencies():
    script_dir = os.getcwd()
    
    for key, info in LIBRARIES.items():
        print(f"📦 Downloading {info['package']} v{info['version']}...")
        url = f"https://www.nuget.org/api/v2/package/{info['package']}/{info['version']}"
        r = requests.get(url, allow_redirects=True)
        
        if r.status_code == 200:
            with zipfile.ZipFile(io.BytesIO(r.content)) as z:
                # We prioritize netstandard2.0 or net6.0 for Linux/CoreCLR compatibility
                dll_files = [n for n in z.namelist() if n.endswith(info['dll'])]
                
                # Filter for the best cross-platform version
                target_member = next((f for f in dll_files if "netstandard2.0" in f), 
                                     next((f for f in dll_files if "net6.0" in f), dll_files[0]))
                
                target_path = os.path.join(script_dir, info['dll'])
                with z.open(target_member) as source, open(target_path, "wb") as target:
                    target.write(source.read())
                print(f"   ✅ Extracted: {info['dll']}")
        else:
            print(f"❌ Failed to download {info['package']}. Status: {r.status_code}")

if __name__ == "__main__":
    download_dependencies()
    print("\n🚀 All identity foundations are now in your directory.")

from sys import path


from pythonnet import load
load("coreclr")
import clr

from pyadomd import Pyadomd

conn = (
    f"Provider=MSOLAP;"
    f"Data Source=powerbi://api.powerbi.com/v1.0/myorg/{WORKSPACE_ID};"
    f"Initial Catalog={MODEL_NAME};"
    f"User ID=app:{CLIENT_ID}@{TENANT_ID};"
    f"Password={CLIENT_SECRET};"
)

query = """
Select [Name] from $SYSTEM.TMSCHEMA_ROLES
"""


with Pyadomd(conn) as conn:
    with conn.cursor().execute(query) as cur:
        print(cur.fetchall())