cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
jhonatas
Frequent Visitor

Update dataset published via Power BI API

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!

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft
Microsoft

@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.

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft
Microsoft

@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.

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.