Automatic Scheduling to Copy of data report to another workspace

[miguelsus2000]

Hi,

I have a report which refreshes and publishes onto the portal every hour.  However, only once a day (at 3 am in the morning), I need to make a copy of the same report and place it in a different workspace. 

I can see it can be done manually, but does anyone know how to schedule this copy activity so it does not require manual intervention?

Thank you.

M

[bcdobbs]

Hi,

When you publish a report to Power BI you will see in the workspace a report which is the layer that describes the visuals and a dataset which contains the data and measures.

The refresh is setup on the dataset.

If I understand your requirement I think the easiest option is to publish the same report to both workspaces but then configure the refresh on each to meet your requirements.

There are other options involves the Power BI Rest API.

[miguelsus2000]

Hi Ben... that is exactly what I need and your idea would work except I have a long standing bug which prevents me from refreshing the data from the portal (powerbi service), so i always have to refresh on the desktop Powerbi app, then publish (I user powerautomate for this). 

I could also duplicate the .pbix files (run the hourly), then publish once per day at 3am, but was hoping for a more solid solution using copy-powerbi powershell command.  Hope this makes sense.

Thank you.

M

[bcdobbs]

Can I ask what the issue is with your refresh? Guessing you're refreshing against an on premise data source? Do you have an issue with the on premise gateway? Solving that would be easiest solution.

[miguelsus2000]

It's multiple issues related to tables...  I have gone down that path of troubleshooting and didn't get me far, so decided to just leave as is.  Saving/not overwriting a data set sounds straightforward, but I guess not to MSOFT yet :-).  I'll have to figure something else out in the meantime.  Thank you...M