Can a Report use Multiple Datasets?

[DanUlrich]

I see question and answer from 2 years ago re: this topic, but needing to do this today.  Can you add another Dataset or several Datasets to a Report?

To me this would be the only way to create a Large Dashboard with Filters and Slicers, is to build one big report, then publish it all to a dashboard.

[toribiolm]

If you download the Power BI add-on for MSExcel, you can connect to multiple datasets and combine the data from them. Not in the same pivot table, but using lookups might work for you

[jowelvizco]

Can you provide the steps in importing the data for multiple datasets from Power BI Service to Power BI Desktop? I already tried this but was limited to only one dataset. Thanks!

[v-frfei-msft]

Hi @DanUlrich,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[RyanAck]

Hi, what are you referring to as a "dataset"? 

Within one report, you can have multiple data sources (i.e. Excel sheet + SQL + web crawl data). You'd just keep adding sources as you need them. 

The exception I've found are Live cube connections, I do not believe you can connect to multiple cubes within one report. 

Does that help?