topic Re: Consuming Fabric Data in On Prem Power BI Report Server in Report Server

Consuming Fabric Data in On Prem Power BI Report Server

Anonymous — Tue, 02 Jul 2024 13:42:11 GMT

Hello,

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

Re: Consuming Fabric Data in On Prem Power BI Report Server

d_gosbell — Wed, 03 Jul 2024 00:23:22 GMT

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.

Re: Consuming Fabric Data in On Prem Power BI Report Server

lbendlin — Wed, 03 Jul 2024 01:40:56 GMT

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

Re: Consuming Fabric Data in On Prem Power BI Report Server

Anonymous — Mon, 08 Jul 2024 01:33:00 GMT

Your ideas is so great lbendlin and d_gosbell

Hi, Anonymous

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.