Forum Discussion
Push data into partition PowerBI model - SSAS
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.
Push datasets are an entirely different thing. You cannot refresh these, and you cannot sub-partition them either.
Hi Anonymous ,
lbendlin Thanks for your concern about this case!
And Anonymous , you can refer to these documents:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#push-data-to-semantic-models
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/
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.
3 Replies
Push datasets are an entirely different thing. You cannot refresh these, and you cannot sub-partition them either.
Thank you LB . Can you point me to any documention or example for these Push datasets. I would like understand how that works.
Hi Anonymous ,
lbendlin Thanks for your concern about this case!
And Anonymous , you can refer to these documents:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#push-data-to-semantic-models
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/
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.