Backup of Power BI Reports

Power BI
1

Hi,

I want to backup by Power BI reports every week and store them in a SharePoint folder with time stamp as the folder name.

Can someone suggest me how can I automate this backup process with out any manual intervention.

Thanks,
Manendra.

2

Hi! Would you please expand on and clarify your needs:

  • Where are your reports currently stored? Are they in Power BI service or Power BI desktop?
  • Is this SharePoint on-prem or SharePoint Online?
  • Do you have access to Power Automate or PowerShell?
  • Do you want to back up the entire report file or just the data?

If there are any other details you can provide, please do so.

3

Hi @ystroman

Thanks for looking into my request. Here are the answers for your questions

Q1: Where are your reports currently stored? Are they in Power BI service or Power BI desktop?
Ans: Reports are published into Power BI services in a Prod workspace.

Q2: Is this SharePoint on-prem or SharePoint Online?
Ans: Every week all reports in the Power BI workspace to be auto backup with a time stamp as the folder name in SharePoint online.

Q3: Do you have access to Power Automate or PowerShell?
Ans: I have access to Power Automate.

Q4: Do you want to back up the entire report file or just the data?
Ans: I want to backup the entire report as all my reports are built using import mode.

5

There are always homegrown solutions; however, they may not
offer the best return on investment. They may also not blend well
into the larger goal of protecting information and data, where it
is always the responsibility of the customer rather than Microsoft.

One such suggestion would be to consider a SaaS Data Protection
Provider such as Keepit for the protection of reports, dashboards,
workspaces, and datasets. The cost per month for a single user
starts at $ 2.95 USD per seat/per month. A free 30-day trial is
available.

Their URL: https://www.keepit.com/services/power-platform/

–

A second such suggestion would be Power BI Sentinal. The cost is not by the seat but rather
by the volume of reports which starts at £250 / $300 per month. on a rolling monthly basis. They do not offer a free trial period but do offer a no-quibble 14-day cancellation and refund policy, so you can try it out without risk.

6

There is value in familiarity with the PowerBI Power Shell commandlets.

The following links provide an introduction:

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

_https://www.sqlshack.com/programmatic-access-to-power-bi-powershell-commandlets/

Also, because you are able to call on a Rest API with Powershell, this is helpful as well:

_Power BI REST API; What it is and Why it is Important - RADACAD

_Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

7

Hello @Bq1BQfLi

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

8

Hi @Bq1BQfLi

We’ve noticed that no response was received from you on the post above.

Just following up if you still require assistance to solve your inquiry.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

9

Hi @Bq1BQfLi,

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!