User Profile
Arya_A_R
Regular Visitor
Joined 11 months ago
User Widgets
Contributions
Re: Trying to convert Natural language generated DAX to the executeQueries .
❌ Failed to execute DAX query. Status code: 400 Response: {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (1, 1) The syntax for 'To' is incorrect. (To obtain the total flying hours of the crew from the dataset you provided, you can use the following DAX query:\n\n```dax\nTotal_Flying_Hours = SUM(Crew_Flying[Flying_Hours])\n```\n\nThis query creates a measure named `Total_Flying_Hours` that sums up the `Flying_Hours` column from the `Crew_Flying` table.)."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3238920194"}}]}}} ❌ Query Error: Failed to execute DAX query: 400 {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (1, 1) The syntax f908Views0likes1CommentTrying to convert Natural language generated DAX to the executeQueries .
I was trying to generate DAX queries corresponding to the natural language input of a user with help of GPT-4o mini. And pass those generated DAX to the Power BI Rest API https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/executeQueries", But i am recieving these errors. Generated DAX Query: EVALUATE SUMMARIZECOLUMNS( "MaxDate", MAX('Date'[Date]) ) ❌ Failed to execute DAX query. Status code: 400 {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (3, 20) Cannot find table '<oii>Date</oii>'."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3241803779"}}]}}}Solved982Views0likes5CommentsTrying to query data with python scripts using power bi rest api
i was trying to access one of the dataset pubhlished in workspace through power bi rest api where i have admin privileges.The error recieved is "403". Below mentioned is the code used to excute the query. def execute_dax_query(workspace_id: str, dataset_id: str, query: str) -> str: """ Execute a DAX query against a Power BI dataset using an embed token generated for the same dataset as get_model_definition. Returns query results as JSON data. """ # Step 1: Generate embed token for the specified dataset gen_token_url = f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/datasets/{dataset_id}/GenerateToken" payload = { "datasets": [ {"id": dataset_id} ], "accessLevel": "read" } headers = { "Authorization": f"Bearer {TOKEN}", "Content-Type": "application/json" } gen_response = requests.post(gen_token_url, headers=headers, json=payload) if gen_response.status_code != 200: return f"Error: Failed to get embed token: {gen_response.status_code} {gen_response.text[:200]}" embed_token = gen_response.json().get("token") if not embed_token: return "Error: No embed token returned." # Step 2: Use embed token to execute DAX query on the same dataset data = {"queries": [{"query": query}]} url = f"{POWERBI_API_URL}/groups/{workspace_id}/datasets/{dataset_id}/executeQueries" result = make_api_request(url, method="POST", data=data, token=embed_token) if "error" in result: return f"Error: {result['error']}" results = result.get("results", []) if results and "tables" in results[0]: return json.dumps(results[0]["tables"], indent=2) else: return Please help me to fix the issueSolved1.3KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.