https://community.fabric.microsoft.com/t5/Developer/Import-a-local-csv-excel-file-by-Power-Bi-REST-api/m-p/702535#M19526 <P>Hi Guys,</P><P>&nbsp;</P><P>I am using a python client and consuming PowerBi REST services. I have a problem with one scenario where I need to import a local csv/excel to add as a new dataset. I tried 'Post Import' api but it only works with pbix file. Also, PostDataset api--&gt;<SPAN>&nbsp;</SPAN><SPAN>POST <A href="https://api.powerbi.com/v1.0/myorg/datasets" target="_blank" rel="noopener">https://api.powerbi.com/v1.0/myorg/datasets</A> won't be of help for this as it's a local file.</SPAN></P><P><SPAN>The purpose is to upload a new csv/excel file and refresh a report based on this dataset.</SPAN></P><P><SPAN>It would be great if someone can help me on this and let me know which api to use and how to do it?</SPAN></P> Wed, 29 May 2019 15:21:47 GMT Anonymous 2019-05-29T15:21:47Z https://community.fabric.microsoft.com/t5/Developer/Import-a-local-csv-excel-file-by-Power-Bi-REST-api/m-p/702535#M19526 <P>Hi Guys,</P><P>&nbsp;</P><P>I am using a python client and consuming PowerBi REST services. I have a problem with one scenario where I need to import a local csv/excel to add as a new dataset. I tried 'Post Import' api but it only works with pbix file. Also, PostDataset api--&gt;<SPAN>&nbsp;</SPAN><SPAN>POST <A href="https://api.powerbi.com/v1.0/myorg/datasets" target="_blank" rel="noopener">https://api.powerbi.com/v1.0/myorg/datasets</A> won't be of help for this as it's a local file.</SPAN></P><P><SPAN>The purpose is to upload a new csv/excel file and refresh a report based on this dataset.</SPAN></P><P><SPAN>It would be great if someone can help me on this and let me know which api to use and how to do it?</SPAN></P> Wed, 29 May 2019 15:21:47 GMT https://community.fabric.microsoft.com/t5/Developer/Import-a-local-csv-excel-file-by-Power-Bi-REST-api/m-p/702535#M19526 Anonymous 2019-05-29T15:21:47Z