Forum Discussion
Fabric REST API executeQueries returns empty results for “TimePoint Background Detail” table while o
I am raising a support request regarding an issue with the Microsoft Fabric REST API endpoint:
POST https://api.fabric.microsoft.com/v1.0/myorg/datasets/{dataset_id}/executeQueries
Issue Summary
When I run a DAX query using the Fabric REST API, all tables return data except one specific table:
TimePoint Background Detail
The table exists in the dataset
Data is visible inside Fabric / Power BI Desktop
Other related tables return valid results through REST API
Only “TimePoint Background Detail” returns empty rows ([]) consistently
is there any specific permission need to access this table via api
Hello SreeAravindM,
Can you confirm that you receive a 200 OK with an empty result [] (rather than a 403 Forbidden or 500 Error) ?
If no "Background" activities occurred during the specific time window you are querying, that table will return an empty list [].
Fabric divides all operations into two buckets.
Interactive Operations:
Opening a Power BI Report.
Clicking visuals (filtering/slicing).
Running a query in DAX Studio or SQL Management Studio.
Result: These appear in TimePoint Interactive Detail (or similar tables), NOT in Background Detail.
Background Operations:
Scheduled Refreshes (Semantic Models, Dataflows).
Spark Job executions (Notebooks).
References :
- https://learn.microsoft.com/en-us/fabric/enterprise/fabric-operations
Hope it can help you,
Best regards !
Antoine
4 Replies
Hello SreeAravindM,
Can you confirm that you receive a 200 OK with an empty result [] (rather than a 403 Forbidden or 500 Error) ?
If no "Background" activities occurred during the specific time window you are querying, that table will return an empty list [].
Fabric divides all operations into two buckets.
Interactive Operations:
Opening a Power BI Report.
Clicking visuals (filtering/slicing).
Running a query in DAX Studio or SQL Management Studio.
Result: These appear in TimePoint Interactive Detail (or similar tables), NOT in Background Detail.
Background Operations:
Scheduled Refreshes (Semantic Models, Dataflows).
Spark Job executions (Notebooks).
References :
- https://learn.microsoft.com/en-us/fabric/enterprise/fabric-operations
Hope it can help you,
Best regards !
Antoine
have you checked if you're hitting a limitation?
Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn
is that a big table? is that a complex query? how many columns, rows are you returning?if you run the same query on DAX Studio how much does it take to return data?
Hi SreeAravindM
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.Hi SreeAravindM
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.
