Push data into partition PowerBI model - SSAS

[vidhyan]

Hello, 
I have a Power BI semantic model. I am creating custom partitions of a table using Tabular Editor/TOM. I noticed that there is a mode called 'push' which is supposed to allow pushing data into the partition instead of the model pulling it from a data source. See documentation below. Following paragraph mentions as 'push data API exposed by Analysis Services'. I am not able to find that API.What does 'push' mean? 

I am looking for an example for this. Also, please let me know if I am not understanding this correctly. 

Partitions in a table

Partitions are represented by a Partition class (in Microsoft.AnalysisServices.Tabular namespace). The Partition class exposes a Source property of PartitionSource type, which provides an abstraction over the different approaches for ingesting data into partition. A Partition instance can have a Source property as null, indicating that data will be pushed into the partition by sending chunks of data to the Server as part of push data API exposed by Analysis Services. In SQL Server 2016, PartitionSource class has two derived classes that represent ways to bind data to a partition: QueryPartitionSource and CalculatedPartitionSource.

https://learn.microsoft.com/en-us/analysis-services/tom/create-tables-partitions-and-columns-in-a-ta...

[lbendlin · Accepted solution]

Push datasets are an entirely different thing.  You cannot refresh these, and you cannot sub-partition them either.

[lbendlin · Accepted solution]

Push datasets are an entirely different thing.  You cannot refresh these, and you cannot sub-partition them either.

[vidhyan]

Thank you @LB . Can you point me to any documention or example for these Push datasets. I would like understand how that works. 

[Anonymous · Accepted solution]

Hi @vidhyan ,

@lbendlin Thanks for your concern about this case!
And @vidhyan , you can refer to these documents:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#push-data-to-sem... 
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-a... 
https://lobsterpot.com.au/blog/2020/07/16/getting-started-with-power-bi-push-datasets-via-rest-apis/ 

And about REST API in push datasets, you can refer to this link:
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets 

Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.