topic Exporting Data from Power BI Report to SQL Server Database Table in Report Server

Exporting Data from Power BI Report to SQL Server Database Table

phbansal — Wed, 20 Mar 2024 16:49:54 GMT

I want to export data from my Power BI Report on Power BI web service into SQL Server Database Table. How can I achieve it without exporting data first into Excel. I want to use Python script for exporting data from my Power BI Report on Power BI web service into SQL Server Database Table. How can I connect to Power BI Report using Python.

Re: Exporting Data from Power BI Report to SQL Server Database Table

lbendlin — Wed, 20 Mar 2024 22:31:14 GMT

Lots of things going on here. You posted this in the Report Server section. Note that the Power BI data in Report Server is already in a SQL Server database.

If you mean Power BI Service then be aware that a Power BI Semantic Model can be accessed via SSAS commands (for example from SSMS or from PowerShell). You can use the standard SSIS packages to do an Export-Import from the SSAS Tabular instance to the SQL Server database.

Having said all that - you're likely holding the problem wrong. Instead of exporting from Power BI you should export from the original data source directly into the SQL Server.

Re: Exporting Data from Power BI Report to SQL Server Database Table

phbansal — Wed, 20 Mar 2024 22:50:27 GMT

Thanks Ibendlin,

Yes, you are right, I mean Power BI Service. I want to export data from report published on Power BI web service into SQL Server Database Table. I don't know the source for this report. I just have that report as a source and I need to export that data into SQL Server table using Python scripts. Can I connect with Power BI Service using Client_ID, Client_secret and token_id?

Re: Exporting Data from Power BI Report to SQL Server Database Table

lbendlin — Wed, 20 Mar 2024 23:07:42 GMT

You might want to look into Semantic Link

Semantic link in Microsoft Fabric: Bridging BI and Data Science | Microsoft Fabric Blog | Microsoft Fabric

Re: Exporting Data from Power BI Report to SQL Server Database Table

phbansal — Wed, 20 Mar 2024 23:31:18 GMT

Thanks Ibendlin for sharing Semantic link in Microsoft Fabric.