sql-bi / pbi-pushdataset Goto Github PK

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.

Scenario 1

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.

Scenario 2

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)

i have aggregated data , they are scans number by date/time of the scan (date hour minute), i have changed the batch row to 31535, and it comes back with error when i run simulation , can you pls advise thanks

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.

Step 1 - Generate command

I used the command line PbiPushTools.exe tool with the generate command, as follows

PbiPushTools.exe generate -model "ssdt_model.bim" -o "NewModel.bim"

Step 2 - Check command

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.

Step 3 - REST API to create Push dataset

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

Question

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.