Can't publish a "Power BI Reportbuilder" Paginated Report (*.rdl) to a Fabric Workspace

[Pilares]

I can't publish a "Power BI Reportbuilder" Paginated Report (*.rdl) to a Fabric Workspace using a data source with a "Microsoft Azure SQL Database" connection type which is reference to a "Microsoft Fabric Warehouse".

At my desktop the report is working according to expectations, however when I want to publish this report to the Power BI Service, the following error is raised (what to do to fix it?):

Operation returned an invalid status code 'BadRequest'

RdlWorkloadErrorCode: 

PaginatedReportAuthoringError

RdlWorkloadErrorMessage: 

Report contains invalid data source: SPA_DB. SQL Server is not supported by the SQL Azure data extension. Please use the SQL data extension instead.

RdlWorkloadErrorTitle: 

RdlWorkloadErrorContractName: 

V1_MessageContainsPiiNonTranslated

RdlWorkloadErrorInternalErrorMessage: 

RdlWorkloadErrorCulprit: 

User

PaginatedReportAuthoringError: 

Report contains invalid data source: SPA_DB. SQL Server is not supported by the SQL Azure data extension. Please use the SQL data extension instead.

HostMode: 

AutoPremium

CapacityObjectId: 

1AA8386F-2904-446A-990E-5E503436EF71

ErrorCode: PaginatedReportAuthoringError 

Details: An unknown error was encountered. Please try again.  

ResponseId: 2f43bc47-dfbe-483c-aafe-1c03b0d5f99f 

ActivityId: 54714cb2-61a0-4d96-a7c1-99ec3a6d6781 

RequestId: 9caba1a6-3de1-47b0-88ed-3557715c9d59 

Timestamp: 20-2-2024 15:00:42 +01:00 

[Pilares_Frank]

Sorry, I (still) don't get it. Could you please point me out to setting the use of the "SQL Data extension"?

[Pilares_Frank]

I already applied the connection type "Microsoft Azure SQL Database". Is the error caused because it's pointing to a Fabric Warehouse? Or should I use another connection type instead? I tried the "Microsoft SQL Server" as well, but that one doesn't allow to use the AD Authenthication.

[Anonymous]

Hi @Pilares ,

As you provided the error message, this is due to: SQL Server is not supported by the SQL Azure data extension. You should use the SQL data extension instead.

Simply change the data source properties in the Power BI Report Builder, then save the report and upload it to your workspace.

Refer to the following solution for detailed steps:

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.