Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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 ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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.