In Power BI Report Builder, in Query Designer, relationships that are in my source, a Fabric Warehouse, are not detected

Maarten van Reek 1 Reputation point
2023-11-22T17:24:43.7533333+00:00

I did a test with Fabric (free trial) to see if the Warehouse storage could be a good datasource for Power BI Report Builder. For this test, I used: https://www.mssqltips.com/sqlservertip/7833/microsoft-fabric-build-data-warehouse/
After the data from the AdventureWorksLT2017 DB was loaded in the Fabric-Warehouse, I added PK+FK constraints to define the relationships between hthe tables.
But in Power BI Report Builder, in Query Designer, these relationships were not detected (so the join-columns I had to add myself):

--

image.png

--

--

image.png

--

I also did the same test for this report with the same DB, AdventureWorksLT2017, but now in Azure SQL (where I also had defined the PK/FK fields), and here it worked OK (so PBI-RB detected the relationships):

--

User's image

--

Could this be a bug in Power BI Report Builder, or maybe it's not prepared for these new Fabric storage modes ( Warehouse/Lakehouse)?

NB: I know that in Fabric I can create a (semantic) model for the Warehouse and define the relationships here, but these are 'Power BI relationships', not the 'normal' relationships in a relational DB (that don't have a cross-filter direction):

--

User's image

--

But I don't want to do any analysis with a dashboard (PBIX-report with a semantic model as a source), I just want a simple paginated report that I can print (RDL-report with a (Azure) SQL as a source)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,867 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-11-23T01:40:17.2366667+00:00

    Hi @Maarten van Reek

    I don't know much about power bi and Fabric Warehouse. Maybe you can go to relevant platforms for help.

    This is the URL of the power bi forum: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi.

    Hope these can help you.

    Best regards,

    Aniya