Import/Modify Power BI Dataset using R

[inawab]

Hi,

How can I Import/Modify Power BI Dataset using R?

using the Get data to get power BI dataset does not allow any modification on the dataset, so I was thinking using R to do all the changes and cleaning.

is it possible to do this? 

Thank you all.

[amitchandak]

@inawab , modification to the dataset should be done in source dataset, you can use restapi, cmdlets and XMLAend point

https://learn.microsoft.com/en-us/rest/api/power-bi/

https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

Using XMLA endpoints to change data sources in a Power BI dataset
https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-d...