Forum Discussion
Solved
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 con...
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~
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~