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 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

Need Help

2 Replies

  • 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.