Forum Discussion
How to delete a column in a Push API dataset?
So the current situation is I grab some data over Power Automate from another system. I then push this data into a Push Dataset which was created via powershell.
I wondered if there was a way to then edit the scheme for the semantic model through PowerBI? I want to be able to delete a column or add a column, is this only achievable through powershell again?
I did try creating a local report in desktop, connecting to the push dataset which is then a live connection, when I went to 'transform data' it says I need to do a DirectQuery via a local copy. That all works fine but then whenever I go to the transform data area to adjust the scheme it just shows a blank screen with Querys (0) in the left side bar. When I'm in the report creation screen I can see the data and create visuals etc
What am I doing wrong?
Thanks
D
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.
4 Replies
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.Hi Mullz ,
We wanted to follow up to see if the provided solutions addressed your needs. If they did, kindly mark them as the solution to assist others. If not, feel free to reach out for further assistance. Thank you!Hi Mullz ,
We just wanted to check in again regarding your issue. If you’ve found a solution, marking the reply as the solution and leaving a kudos would be greatly appreciated—it helps the community and others with similar questions.
If you’re still facing challenges or have further questions, please let us know—we’re here to help and would love to assist you in resolving this.
Looking forward to hearing back from you!
Best regards.
