Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Connect multiple power BI data sets in the same report

Hi, we have multiple Live Power BI reports and we would like to connect them to a single Power BI report.  Any ideas on how to do this?

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    By Connecting to a Report, I suppose you mean to Connect to Reports' Dataset. If that is the case, You will have to publish the First Report containing all Data in Import Mode. Then, you can connect the various reports to the Dataset of the First Report by Choosing Power BI Datasets under Get Data. Please make sure that the Account under which you have published the first report and the Account that you are using to Connect to the Published Dataset are the same.

     

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

  • Hi Anonymous ,

     

    Did you mean conneting to power bi dataset in power bi desktop? That is a kind of live connection, so we cannot connect multi datasets at the same time.

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    By Connecting to a Report, I suppose you mean to Connect to Reports' Dataset. If that is the case, You will have to publish the First Report containing all Data in Import Mode. Then, you can connect the various reports to the Dataset of the First Report by Choosing Power BI Datasets under Get Data. Please make sure that the Account under which you have published the first report and the Account that you are using to Connect to the Published Dataset are the same.

     

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Did you mean conneting to power bi dataset in power bi desktop? That is a kind of live connection, so we cannot connect multi datasets at the same time.