Forum Discussion

LiamReidy's avatar
LiamReidy
Helper I
4 years ago
Solved

Multiple datasets into 1 report

Hello Power Bi Community,   I have a use case where i am trying to create a report in power bi using 2 separate excel files held within a sharepoint site. Both datasets are loaded into my workspace...
Need Help
  • Burningsuit's avatar
    Burningsuit
    4 years ago

    Hi LiamReidy 

    You're correct, you can create a Dataflow with a Pro Licence, but you can't create a report from it unless you use Power BI Desktop (or Datamart). You could merge the two tables in the Dataflow, but merging requires a PPU licence or better.  You could of course merge the two tables manually in Excel to create one and report on that but that would be a manual step. If you had Desktop, the Dataflow becomes unnecessary as you can just connect to the two Excel tables. Without Desktop, it seems you have no other option in Power BI. 

    Hope this helps

    Stuart

     

LiamReidy's avatar
LiamReidy
Helper I
4 years ago

Hi Burningsuit ,

 

We dont have PPU or Gen 2 access at the moment. Are you aware of any other workarounds? I tried to create a dataflow in Power Bi Service but it seems this cant be published in a report.

 

Thanks,

Liam

Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

Hi LiamReidy 

You're correct, you can create a Dataflow with a Pro Licence, but you can't create a report from it unless you use Power BI Desktop (or Datamart). You could merge the two tables in the Dataflow, but merging requires a PPU licence or better.  You could of course merge the two tables manually in Excel to create one and report on that but that would be a manual step. If you had Desktop, the Dataflow becomes unnecessary as you can just connect to the two Excel tables. Without Desktop, it seems you have no other option in Power BI. 

Hope this helps

Stuart