sql-bi / pbi-pushdataset Goto Github PK
View Code? Open in Web Editor NEWValidate and translate regular Tabular models in Push Datasets, also providing helper functions to clear, populate, and simulate real-time transactions.
License: MIT License
Validate and translate regular Tabular models in Push Datasets, also providing helper functions to clear, populate, and simulate real-time transactions.
License: MIT License
When generating the model using the Console App, it saves a model which if we try to post the data via Power BI API documentation playground (https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset), and in body we use the output content, we get the following message from Power BI API:
{ "error": { "code": "BadRequest", "message": "Bad Request", "details": [ { "message": "The property 'compatibilityLevel' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Dataset'. Make sure to only use property names that are defined by the type.", "target": "dataset" } ] } }
Comparing both Model.bim and out.bim they look like the same, meaning the output result of the generate command does not look like the correct content/intended.
Running the check command it validates de Model.bim successfully.
Can you help?
Hi,
I am stack, I run the script and I am gettig the following error message:
** PUBLISH model **
Publish-PushDataset: One or more errors occurred. (Operation returned an invalid status code 'Unauthorized')
Mention that I followed all the steps and configured the app inside azure and grant privileges in Azure and Power BI Service. What I am doing wrong?
I don't see any explanation in the readme. Thanks
Hi All,
I like the idea of push datasets. I have been following your wonderful guidance in the link below:
https://www.sqlbi.com/articles/implementing-real-time-updates-in-power-bi-using-push-datasets-instead-of-directquery/
In this article you have specified the following:
Please help me understand the deeper implication of this limitation.
Since PBI supports only 1 active relationship between a parent and child table- this effectively rules out the possibility of some parent table having relationships to more than 1 child table.
I cannot have a Products table which is referenced by Sales table and also by Orders table.
Does it mean , that I cannot have a more than 1 relationship between the 2 tables. E.g. OrdersTable and a DateTable could have multiple relationships. (OrderdReceivedDate , OrderFullFilmentDate)
Hi,
I've create a new dataset and I need to update the model.
Does the Set-PushDataset update the retention policy of the dataset? Since this parameter is not available for this cmdlet
I am guessing Tabular Editor.
Are there any compatibility/caveats that I must be aware of.
Thanks,
Sau
Can I use the BIM file generated by an Analysis Server project in Visual Studio?
This way, I get to GIT control my model file and do CI/CD and Pull Request reviews for any model changes.
The binary nature of PBIX/PBIT makes it very hard to do a sensible quality control during development time.
Thanks,
Sau
hi there
i keep getting errors when i try to generate simulation json file for my data fields, where can i find the exact data type that is accepted Sqlbi.PbiPushDataset.SimulationType,
here is the exact error
Unhandled exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> Newtonsoft.Json.JsonSerializationException: Error converting value "string" to type 'Sqlbi.PbiPushDataset.SimulationType'. Path 'tables[0].columns[0].type', line 10, position 36.
---> System.ArgumentException: Requested value 'string' was not found.
Hi All,
I have a BIM file generated by SSDT. This is very basic for now . Just 2 tables.
I want to create a Push dataset.
I used the command line PbiPushTools.exe tool with the generate command, as follows
PbiPushTools.exe generate -model "ssdt_model.bim" -o "NewModel.bim"
I then ran the check
command as follows
PbiPushTools.exe check -m "NewModel.bim"
The output was as follows:
** CHECK model **
Checking model: **\NewModel.bim
Model validated.
I used the following REST end point via POSTMAN
https://api.powerbi.com/v1.0/myorg/groups/[workspaceid]/datasets as documented by Microsoft here
I used the JWT token via Get-PowerBIAccessToken
I was under the impression that the tool would convert a BIM file to a model file compatible with PUSH dataset rest api.
Microsoft's REST API for creating a PUSH dataset does not appear to be liking the model file that was created by PbiPushTools.exe
. SSDT model attached.
What am I doing wrong?
Thanks,
Sau
Model - Copy.zip
I followed all the documentation of Installing the tool and also created app on AAD with following the instruction on how to build Service Principal application to use Power BI services can you give me more insights. Please and Thank you.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.