Forum Discussion

CEllis's avatar
CEllis
Icon for Resolver I rankResolver I
4 years ago
Solved

DAX - Report Designer

Hi,

 

Wounderd if any one could clarify.

 

I am using the performance Analyzer in PowerBi Desktop to generate the DAX query and copy that into the PowerBi Report Designer Query. Once I publish the PowerBi Desktop to a premium workspace then run the Report Deisigner quey it all works.

 

What I am getting confused with is why this still works with fields from different tables without needing to creat relationships with the tables.

 

Hope this makes some sence.

 

Many thanks

 

Chris

  • amitchandak's avatar
    amitchandak
    4 years ago

    CEllis , Are you creating that report(Report builder report) using the power bi dataset? if yes, that already has all information

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    CEllis , Are you creating that report(Report builder report) using the power bi dataset? if yes, that already has all information

    • CEllis's avatar
      CEllis
      Icon for Resolver I rankResolver I
      4 years ago

      amitchandak , Yes thats right. 

      I am creating a visual table in PowerBi Desktop that uses fields from different tables then publising it.

       

      Then using the performance analizer to get the DAX query and pasting it into the PowerBi Report Designer.

       

      I thnk what I find confusing is that it doesnt look like the releationships are handled in Report Designer which I think is what you are saying. They are handled in the Published PowerBi Dashboard.