push data to an existing dataset which is imported from a pbix file

[leelachandrappa]

We are working pulling custom logs from log analytics using KUSTO query and push this data to power bi and create visualizations using this data through an automated process.For now we have implemented this Using Powershell scripts, We are able to pull data from log analytics to a csv file and then push this data to power BI dataset.

As per limititation powerBI , We cannot automate report creations . Hence we imported a pbix template file and tried to append data to an existing dataset through powershell but it is now working . Is there a way where we can push data to an existing dataset which is imported from a pbix file 

[v-angzheng-msft]

Hi, @leelachandrappa 

Here are some references that may be helpful

https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data

https://community.powerbi.com/t5/Developer/Updating-Data-with-Push-Push-Data-Sets/m-p/898558

https://petri.com/how-to-push-data-via-powershell-to-powerbi

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[leelachandrappa]

Hello,

Thanks for your response !

 I have gone through these and didnt get much information ! 

Is there way where we can push data to an existing dataset which is imported from a pbix file ?

[v-angzheng-msft]

Hi, @leelachandrappa 

Isn't the first document what you want? it describes how to push the dataset to an existing dataset. 

Push data into a Power BI dataset

The Power BI API lets you push data into a Power BI dataset. In this article, we show you how to push a Sales Marketing dataset containing a Product table into an existing dataset.

Best Regards,
Community Support Team _ Zeon Zheng

[leelachandrappa]

Hi,

We are using powershell to push data to a dataset. We created a dataset using rest API and was able to push data to that dataset created using rest API through powershell. 

But when we import a pbix file and push data to the dataset which is imported from the pbix file we are not able to do and get following error.

VERBOSE: Status Code: NotFound (404)
Add-PowerBIRow : Operation returned an invalid status code 'NotFound'

Would like to know if this is possible  and if yes how to accomplish this?

[v-angzheng-msft]

Hi, @leelachandrappa 

From the error reported above, it seems that some parameter is not correct causing the object not to be found.

It seems to be a complicated process and no one knows exactly what went wrong since all we don't know what operations you performed. Unfortunately I have no experience with the situation in question and if I find a solution I will post it here, but for now, hope someone can help you out.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[leelachandrappa]

Hi , 

Thanks for your response ! The same code works for push data to an existing dataset created through an API but does not work on the imported dataset from pbix.

Powershell code was created to create a dataset if it doesnt exist and if the dataset exists then it will just go and push data to that dataset.

Hoping to get an answer soon .

[asdasdadadsf]

First you need to check your dataset using GET /datasets and see whether the addRowsAPIEnabled is set to true. This would be the case if you were creating a Push Dataset. However since you are Importing a report, it creates a new dataset for you, that you cannot set to an existing one, and that dataset would not be a Push Dataset, thus addRowsAPIEnabled is likely false.

I am struggling to create a .pbix template, publish this report, clone this report to a new push dataset, and be able to download a new .pbix file from that new report. It doesn't seem to be possible after the template report is Cloned, which is painful.

The alternative for me would be to do something like what you are doing, to Import my template .pbix file to a new report so I can download the new .pbix file, but since I can't Import to an existing push dataset, it has to create a new dataset, and my efforts to keep that dataset up to date are much more complicated than simply adding new rows via the push dataset.

Can the community leads provide input on this feature? We need to be able to download .pbix files from reports that have been cloned and associated with an existing push dataset.