Consuming Fabric Data in On Prem Power BI Report Server

[joel_silveira]

Hello,

Does Report Server have access to MS Fabric Data? (Lakehouse, DW, etc)

[Anonymous]

Your ideas is so great @lbendlin and @d_gosbell 

Hi, @joel_silveira 

As the super user said, you can't use the contents of the fabric directly on the report server:

We can host paginated reports or normal reports into Report Server.
If you want to work with your fabric's content, you can use the following two tools:
Connect to your Fabric's project in Report Builder:

Connect to your Fabric content in the Power BI RS release:

With the above two methods, you should be able to use your fabric content correctly. After you have finished designing your report, you can publish your report to Report Server.

Jianpeng Li

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

[lbendlin]

Sort of.  The SQL endpoint of a data warehouse is accessible from anywhere given the right authentication.

Query the SQL analytics endpoint or Warehouse - Microsoft Fabric | Microsoft Learn

[d_gosbell]

Not really. You can import data into desktop from Fabric and publish that static snapshot to an on-prem Report Server, but you cannot schedule refreshes as the on-prem report server is not integrated with Entra ID.

If your data is in Fabric you should deploy your reports to a Fabric workspace also.