Forum Discussion
Exporting Data from Power BI Report to SQL Server Database Table
You might want to look into Semantic Link
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.
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?
You might want to look into Semantic Link
Thanks Ibendlin for sharing Semantic link in Microsoft Fabric.