Forum Discussion

harshaSampath81's avatar
harshaSampath81
Icon for Helper II rankHelper II
8 years ago

How do we share one table in two data set and create report using two data set

Hi   I have two questions..   1st  ............ How do we Create one report using two data set (both dataset are from one database), is there any method to do that? 2 nd .......... Because My ...
Need Help
harshaSampath81's avatar
harshaSampath81
Icon for Helper II rankHelper II
8 years ago

My Data Source is SQL Server,

 

I reduce the table of the main data set and save as new PBIX file and publish as another dataset like wise reduce the complexitiy of the main Data set 

 

 

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Get the data set from Power BI service

 

  • harshaSampath81's avatar
    harshaSampath81
    Icon for Helper II rankHelper II
    8 years ago

    Hi SivaMani

     

    Here How do we Load two data set at once . I think it is not possible to do that.. is there anyway to create report using two dataset at same time, and how to create common table for two data set without creating two table for each data set

     

    Harsha

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident Rockstar
      8 years ago

      We have an option - Append Queries

       

      Hope It will help you!