Forum Discussion

Mann's avatar
Mann
Icon for Resolver III rankResolver III
6 years ago

Power BI Report Builder Issue Showing data from different Dataset in same page

Hi Guys,

 

I am working on a Power BI Report builder and our source is Azure Analysis Services in a live connection.

The requirement is to create following kind of report.

 

  • Line Chart will be created from Table A (Dataset A) which has records every 5 min.
  • We need to show some 5 KPIs which are coming from different table i.e. Table B (Dataset B)
  • We need to have some grouping in place like: Vendor etc. For Vendor: xxx report should show two classes of vendor xxx as Vendor Class A and Vendor Class B. KPIs should also get filtered based on these clasess. This should get repeated for other vendor on each page.

I created the line chart and calculations for KPIs. I am facing issues in inserting both the datasets, Dataset A for line charts and Dataset B for KPIs within a single grouping of vendor as they are coming from different dataset.

 

Does any body know how this can be done in Paginated reports?

 

Thanks

Need Help

2 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Mann ,

    This video may help you.

     

    Best Regards,

    Icey

     

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

     

    • Mann's avatar
      Mann
      Icon for Resolver III rankResolver III
      6 years ago
      Hi Icey,

      Thanks for the reply. I have seen this video. I am afraid, I cant put a join on these two tables or dataset due to issues with granularity. If I go with this approach it results into redesign of 10 measures.

      I got to learn that these requirements are possible in SSRS using sub reports but in paginated report we dont have this feature.

      I am putting these datasets horizontally now.

      Let me know if you have any other way of doing this.
      Thanks