Update dataset published via Power BI API

[jhonatas]

Hello guys!

Today im doing some tests with Power BI API.

I already downloaded the console sample and the web sample. And created some datasets/reports to test.

I used the console app do do this, the option was "6 - Import PBIX Desktop file into an existing workspace".

This works good, but now my doubt is, how i can update the previosly created dataset?

Searching around i found the AddRows method but im afraid that this is not a trivial thing. In the examples i see they create a json with the new rows and add to the table. I think im misunderstanding something. When i update my desktop pbix file i dont know what is the new rows? Someone can help me here? Thanks in advance!

[Eric_Zhang · Accepted solution]

@jhonatas

You can do the update by re-importing the new pbix file.

There's an argument nameconfilict for PostImportWithFileAsync, and as per this github sample, the argument value "Overwrite" can be used to overwrite the already existing dataset. However "Overwrite" seems a invalid status code based on my testing and I haven't found the correct status code yet so far.

As a workaround, you might to use the PowerBI-Cli to overwrite, check Updating existing workspaces with a new pbix file #22.

[jhonatas]

Yeah, nameConflict parameter works here!

At the beggining i was getting error when i have two files with the same dataset name.(idk, but this is possible), so the overwrite dont know what file to replace.