Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I create the report, everything runs ok in the report builder
I connect to the Fabric Warehouse
I can run the report from inside the report designer
When save to SQL Report server, and try to run the report, I get the following error
I want to include this in an embedded report, so I can't just publish the report on fabric, since I'm only on F8
Hi @Founder ,
Power BI reports can connect to a number of data sources. Depending on how data is used, different data sources are available. Data can be imported or data can be queried directly using DirectQuery, or a live connection to SQL Server Analysis Services. Some data sources are available in Power BI Desktop that is optimized for use with Power BI Report Server, but they aren't supported when published to Power BI Report Server.
Fabric Warehouse are not supported when published to Power BI Report Server.
For more details, you could read related document: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Why are they available as options in the application if they can never be used in production?
I'm looking at options for using Fabric with an F8 SKU from an embedded Power BI report.
All options seem to be too expensive for the use case.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
5 | |
2 | |
2 |
User | Count |
---|---|
13 | |
7 | |
6 | |
2 | |
2 |