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.

Hi DanUlrich In Power Bi service, you can create multi reports by the same dataset, However you cannot create one report by using different dataset. One way to work around, creating dashboard could combine different visuals from different reports. Also you can connect to all the data sources of different datasets and import the data by Power BI desktop, then you can use all the data. Regards, Frank

Can a Report use Multiple Datasets? | Microsoft Fabric Community

24 Replies

v-frfei-msft
Community Support
7 years ago
Hi DanUlrich

In Power Bi service, you can create multi reports by the same dataset, However you cannot create one report by using different dataset. One way to work around, creating dashboard could combine different visuals from different reports. Also you can connect to all the data sources of different datasets and import the data by Power BI desktop, then you can use all the data.

Regards,

Frank
- Anonymous
  Not applicable
  4 years ago
  Hi folkfs,
  DUe to a new Direct Query features in preview now you CAN now use two Power BI service Dataset in the same report, when creating a local model. There are limitations, but it works. More info there
  <https://docs.microsoft.com/fr-fr/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services>
  - rjs2
    Resolver I
    4 years ago
    Did something change recently? I was able to do this until today.
    
    I keep getting this error: Details: "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."
    
    my existing reports which I have multiple data sets still work. But I can not combine new ones anymore.
- nqzhhzmn
  Advocate II
  4 years ago
  This is no longer correct. Please see below answer by Maignan or
  Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs
- jowelvizco
  Regular Visitor
  7 years ago
  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!
RyanAck
Advocate I
7 years ago
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?
Anonymous
Not applicable
4 years ago
You can now create one report with multiple datasets through DirectQuery (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services). If you are having trouble setting up DirectQuery (ex. getting the "The connect live option for this file is disabled" error), make sure this is enabled below.
Anonymous
Not applicable
5 years ago
Anyone is able to import the data from different datasets?
Could you provide the steps?
Anonymous
Not applicable
5 years ago
Dashboard formatting options are very minimal and resolution on different laptops are causing it - confusing to users.

Going back from Dashboard to report and navigating back to Report - that UI isn't intuitive as well.

Back button is all the way on bottom left corner of screen - hence, on different screen resolution laptop , it gets hidden. Kind of hard to explain this to business users.

Hopefully Power BI improves the dashboard features and functionality!
aleksvp
Helper II
4 years ago
I do want to do this for a particular reason. Most of my data if on a database, but a small part is on a spreadsheet in onedrive, for which I need to scheduled a periodic refresh. When I publish my report, all the data is considered as one dataset, so I can not scheduled the refresh for the spreadsheet. Any solutions?
One thing I tried was creating a dataset on PowerBI Service, than tried to import it via PowerBI Desktop using the option Get data-> Power BI data sets. But, for a reason I do not know, the dataset I've created does not appears as a option, only the others created when I publish reports.
- Anonymous
  Not applicable
  4 years ago
  You can get the speadsheet through the OneDrive link (https://www.youtube.com/watch?v=a--TpY5sYqk). From there, you can pull your data from the database using the dataset you published. Publish this report/dataset, and then schedule the refreshes!
  - aleksvp
    Helper II
    4 years ago
    I did this, but the point is: on my report there is data from the spreadsheet and from a database. When I publish on powerbi service, it all became a single dataset, so I can not schedule the refresh to the data that came from the spreadsheet since powerbi service see it all as a single dataset.
Anonymous
Not applicable
4 years ago
aleksvp

The turn-around for your problem may be that you can turn-off the refresh data option of the table that are loaded from the databace and turn-on the tables that are loaded from the onedrive.

This can be achieved in Power BI desktop

Power BI Desktop > Home > Transform data > Click on table name > Click on All Properties on right side > uncheck include in report refresh option

The tables unchecked will not load when refreshed in Power BI Service.

Hope this answers your questions

Thanks
Syed
Anonymous
Not applicable
4 years ago
or use a dashboard and pin all the reports
Intro to dashboards for Power BI designers - Power BI | Microsoft Docs