Switch an existing Power BI report to a new datasource (Push-dataset)

[Anonymous]

Hi all,

I have designed a report in Power BI Desktop now published in Power BI.

Now I'm trying to switch it to a push-dataset. Is it possibile?

Thank you

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

You could try Push DataSet API ,check a similar thread below:

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

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , I did not get what to mean by push dataset, can you elaborate.

But you should be able to change datasource either in data source setting or in advance editor power bi

[Anonymous]

@amitchandakThank you for your reply.

I read about push dataset here https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

My dataset is the second type, I used Power BI Desktop to design reports and then I published it in Power BI.

I use an ETL software to transform my data which exports files in .csv but I have just discover than maybe I can literally "push" those files in Power BI without export in .csv .

But when I try to do it returns error:

The only thing I can do is to create a new dataset (which is a push-dataset) and design new report in Power BI.

My wish is to switch my existing report to this new datasource.