Fabric REST API executeQueries returns empty results for “TimePoint Background Detail” table while o

[SreeAravindM]

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 

[v-aatheeque]

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.

[v-aatheeque]

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.

[R1k91]

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?

[AntoineW · Accepted solution]

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