Forum Discussion

Cathy99's avatar
Cathy99
New Member
3 years ago

sortByColumn in Push Dataset not working

I am embedding a powerBI report into a website and I need to use push dataset to get live connection. I am creating a Push Dataset using API call: POST https://api.powerbi.com/v1.0/myorg/groups/{gro...
Need Help
freginier's avatar
freginier
Icon for Solution Sage rankSolution Sage
4 months ago

Hi Cathy99,

This is a known limitation with Push Datasets. Unfortunately, the sortByColumn property in the Push Dataset API schema is not currently supported and is silently ignored by the service — the column sort-by settings must be configured manually in Power BI Desktop after the dataset is created.

Here is the workaround:

1. Open your Push Dataset in Power BI Desktop (connect via the Power BI service).
2. In the Data view, select the LOG_DAY column.
3. In the Column tools ribbon, click Sort by column and select DAY_ID.
4. Save and publish the report.

Note that this manual setting will persist in the report, even as data is pushed to the dataset.

If you want this behavior to be supported natively via the API, I would encourage you to submit this as a feature request on the Fabric Ideas board.

Hope that helps!