Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
Solved! Go to Solution.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |