Forum Discussion
how to do DAX queries in python?
Pessoal, estou tentando criar um comando em Python para executar uma consulta DAX em um conjunto de dados. Já consigo visualizar o relatório usando o bloco de anotações Jupyter no vscode, mas não consigo criar um comando para executar uma consulta DAX.
Hi rafaelbruno ,
You can try the following python script.
from sys import path path.append(r'C:\Program Files\Microsoft.NET\ADOMD.NET\160') # Modify to the corresponding path on your computer from pyadomd import Pyadomd import pandas as pd server = "powerbi://api.powerbi.com/v1.0/myorg/WorkspaceName" username = '[email protected]' password = 'xxxxxxxx' dataset = 'Dataset Name' conn_str = f'Provider=MSOLAP;Data Source={server};Initial Catalog={dataset};User ID={username};Password={password};' query = """ EVALUATE TableName """ with Pyadomd(conn_str) as conn: with conn.cursor().execute(query) as cur: df = pd.DataFrame(cur.fetchall(),columns=[i.name.split('[')[-1].split(']')[0] for i in cur.description]) print(df.head())Or use the PowerBI REST API.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
1 Reply
Hi rafaelbruno ,
You can try the following python script.
from sys import path path.append(r'C:\Program Files\Microsoft.NET\ADOMD.NET\160') # Modify to the corresponding path on your computer from pyadomd import Pyadomd import pandas as pd server = "powerbi://api.powerbi.com/v1.0/myorg/WorkspaceName" username = '[email protected]' password = 'xxxxxxxx' dataset = 'Dataset Name' conn_str = f'Provider=MSOLAP;Data Source={server};Initial Catalog={dataset};User ID={username};Password={password};' query = """ EVALUATE TableName """ with Pyadomd(conn_str) as conn: with conn.cursor().execute(query) as cur: df = pd.DataFrame(cur.fetchall(),columns=[i.name.split('[')[-1].split(']')[0] for i in cur.description]) print(df.head())Or use the PowerBI REST API.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~