Forum Discussion

KevinSJC's avatar
KevinSJC
New Member
4 years ago
Solved

Adding a table multiple times to the same dataset

I need a way to query data from one common table multiple times, looking for different results. Yes, I could use a subreport, but for other reasons, it won't help. Here's a example of what it is I'm ...
dataset
report builder
same table
  • KevinSJC's avatar
    KevinSJC
    4 years ago

    Hi!

     

    I figured it out on my own. I tripped over the LOOKUP function and played around with it. I was able to use it to solve my problem. Thanks all for your help!

     

    Kevin

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, KevinSJC 

 

For your needs, the easiest way to implement should be to connect the model in the desktop first, then create the relationship, and the corresponding table, then copy the query to the report builder.

You can patiently check the following documents, which are very detailed:

Reference:

Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs

Solved: Paginated report - nested tables with different da... - Microsoft Power BI Community

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

KevinSJC's avatar
KevinSJC
New Member
4 years ago

Hi Janey!

I now question if I'm in the correct forum as I don't use Power BI. I am developing reports on SSRS using MS Report Builder. When I went to their help section looking for documentation, there was a community link that brought me here. I just figured Power BI must be a rebranding campaign, but I'm not so sure based on yours and the other response I received. Is there a better forum I should be in for MS Report Builder?