Moving Data from PowerBI report to a RDBMS

[Vivek26]

Hi All , 

We have built a data model in PowerBI , Wrote some calculated columns and complex measures to finally acheive meaningful report output. The report is well received and is highly used by users but now they want to utilize the output of the report calculations into other tools as well . So they want us to make the final data available on the Database as well.

We have 2 options here. 

1. Push the entire code to  and calculation Logic to DB.

2. Push the output of the report to a DB table 

Can you please let us know the feasibility of the second option and if any additional licensing would be required for it ?

[elitesmitpatel · Accepted solution]

Hey @Vivek26 
Here are few things you can consider

• Using Power BI Dataflows:

  • Dataflows allow you to extract, transform, and load (ETL) data in the Power BI service.
  • You can use Power BI Dataflows to store the data in Azure Data Lake Storage, which can then be accessed by other tools.
  • This method may require Power BI Premium, as Dataflows are a premium feature.

• Using Power BI REST API:

  • The Power BI REST API can be used to export data from Power BI datasets and reports.
  • Custom scripts or applications can be created to fetch the data and push it into a database.
  • This approach typically requires development resources to create and maintain the necessary scripts or applications.

• Power Automate Flows:

  • Power Automate (formerly Microsoft Flow) can be used to automate the process of exporting data from Power BI to a database.
  • You can create a flow that runs on a schedule or is triggered by an event, exporting data from Power BI and inserting it into your database.
  • Power Automate can integrate with various databases like SQL Server, Azure SQL Database, and more.

• Paginated Reports:

  • Power BI Paginated Reports can export data to a variety of formats (e.g., CSV, Excel).
  • These exported files can be automated to be pushed into a database using additional ETL tools or scripts.
  • Paginated Reports require a Power BI Premium license.

Hope it helps , please Accept it as Solution that will help other community member.