Forum Discussion

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

Paginated Reports - PowerBi Data Source - Joins

Hi,   I have had a look around about joining different datasets(tables) from the same PowerBi Data source and find it confusing if this is possible or not.   This is how I am building reports in ...
Joins
Paginated Report Builder
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi CEllis ,

 

In Report Builder, you can add a shared data source from the report server or create an embedded data source for your report.
For the second half of your statement, it seems not quite understandable. Can you provide the relevant step-by-step information, etc.

 

related document:

Add and Verify a Data Connection (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs

Set Credential & Connection Information for Report Data Sources - SQL Server Reporting Services (SSRS) | Microsoft Docs


Best Regards,
Henry


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

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

    Hi Henry,

     

    Thanks for your respone, its much apprecited.

     

    Hopfully this wil help;

     

    I've mocked up an example below.

     

    If I use fields from seprate tables are they joined or do I have to creat the join ?

     

    The only functions I have come across are 'Lookup' and 'LookupSet' that come close to joining seprate tables.

     

    Many thanks

     

    Chris