PBI Rest API - Any way to Clone/Publish a dataset?

[Anonymous]

Hello all,

I'm wondering if there's any way of using Power Automate to clone a dataset from one workspace to another. I know that there's likely not a direct way of doing it, but has anyone come up with a round-about way? 

For example, is there  a way to publish a dataset from a folder in sharepoint using Power Automate? 

Thanks,

Chris

[lbendlin]

I think there are enough API calls to accomplish what you want, for example

https://docs.microsoft.com/en-us/rest/api/power-bi/imports/postimportingroup

HOWEVER:  What you will find is that Power Automate has SEVERE limitations when it comes to file sizes.  It craps out at above 100000KiB web message size and 250000KiB file size on sharepoint/Onedrive.

So this will only work for tiny datasets. Not sure if Powershell has the same limitations.

[Anonymous]

Thanks for this. In my searching this looks like the most promising option.

What I'm having a hard time understanding is how to properly call the file that I'm hoping to import? Where does it have to be stored and how do I use the header statement to call it? Can it be stored in sharepoint and called from there? The size limitation is not a concern.