Power BI Push Tools is a set of open-source tools to work with Power BI push datasets.
Read Implementing real-time updates in Power BI using push datasets instead of DirectQuery to learn the architecture of solutions based on push datasets and how to create and populate a push dataset starting from a regular Tabular model.
The projects available in the GitHub repository are:
- Sqlbi.PbiPushDataset: It is a library based on .NET Core 3.1, which is compatible with Azure Functions. This library can be used directly by your C# or .NET code in case you do not want to rely on PowerShell or command-line tools to create and maintain the push dataset model. The library is available also as a NuGet package.
- PbiPushTools: It is a command-line tool that internally uses the Sqlbi.PbiPushDataset library and does not require any programming skill to create, maintain, and test a push dataset model. No setup required, just download the ZIP file, expand the content in a folder included in the path, and execute the command line version PbiPushTools.exe.
- Sqlbi.PbiPushTools: It is a PowerShell cmdlet to create, maintain, and test a push dataset model. The cmdlet internally uses the Sqlbi.PbiPushDataset library and is an alternative to the command-line tool. The PowerShell cmdlet is compatible with PowerShell scripts managed by Azure Functions, and it is available in the PowerShell Gallery.