Forum Discussion
How to delete a column in a Push API dataset?
Hi. I'm not an expert in push datasets but I think you can do it with the Power Bi Rest API. You can use powershell or any code language like python.
The request is this one: https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-put-table-in-group
I says it let you update the schema. Maybe that is what you need now.
I hope that helps,
P/D Consider that push datasets will be deprecated at 2027. It was announced.
Hi Mullz ,
Thanks for reaching out,
When you connect to a Push Dataset in Power BI Desktop using a live connection, you’re directly querying the dataset schema that resides in the Power BI Service. The Transform Data feature (Power Query Editor) is disabled in this mode because you’re not working with a local copy of the data.
Reason for blank screen in transform data:
After attempting to load the data in DirectQuery mode for a local copy, you're seeing a blank screen with Queries (0) in the left sidebar because you're still accessing the dataset as a live connection. Even though you’re in DirectQuery mode, Power BI doesn’t load editable queries for live connections.
Work Around for this:
1. As mentioned by ibarrau you can use Power BI REST API or PowerShell to update the schema of the Push Dataset.
2. Switch to DirectQuery or Import Mode:
If schema transformation in Power BI Desktop is required:
- Export your Push Dataset's data to an intermediary storage like SharePoint or Azure SQL.
- Reconnect using DirectQuery or Import Mode in Power BI Desktop, which allows full access to the Transform Data features.
3. Microsoft Real-Time Intelligence
Given that Push Datasets are being deprecated in 2027, a future-proof approach would be to consider Microsoft Real-Time Intelligence solutions, such as Event Streams and Lakehouses in Microsoft Fabric. These solutions allow you to manage schema changes and real-time data processing much more efficiently, without the limitations of Push Datasets.
Announcing the retirement of real-time streaming in Power BI | Microsoft Power BI Blog | Microsoft Power BI
Hope these help.
If this post helps, please consider accepting as solution to help others benefit and a kudos would be appreciated.
Best Regards,
Vinay.