Forum Discussion

ranbinho's avatar
ranbinho
New Member
9 years ago

Multyple datasets for same file

Hi,

 

I want to create 2 datasetrs in the same file so I can use both of them for one report.

 

Can I do this with the desktop app?

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    You can import as many tables as you need into a data model, but it is only 1 dataset. 

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    ranbinho

     

    You can get data with Import mode from different data sources. For example you can get many tables from an excel file and a SQL database in one PBIX file. Then you can use the data from different imported tables in one report.

     

     

    Best Regards,

    Herbert