Forum Discussion

SreeAravindM's avatar
SreeAravindM
Regular Visitor
8 months ago
Solved

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 Summ...
admin
capacities
security
workspaces
  • AntoineW's avatar
    AntoineW
    8 months ago

    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

v-aatheeque's avatar
v-aatheeque
Community Support
8 months ago

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's avatar
v-aatheeque
Community Support
8 months ago

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.