March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to Solution.
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
or use a dashboard and pin all the reports
Intro to dashboards for Power BI designers - Power BI | Microsoft Docs
@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
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.
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!
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.
If you refresh that dataset it should still refresh that spreadsheet. Could you change a few values to test it out?
The problem is I can't refresh the database, cause it is local and I can't use a gateway.
As explained in earlier reply of mine .. you can confirure which table/field needs to be refreshed when a start a refresh in local or service .. so you need to turn on the refresh for only table that is loading from share point and turn off other tables
So you only want to refresh the spreadsheet? How did you connect to the database originally without the gateway?
So you only want to refresh the spreadsheet? Yes
How did you connect to the database originally without the gateway? You do not need a gateway to connect to the database, just need it to automatic refresh
So when you hit you refresh, is it giving you an error?
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-s...). 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.
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!
Anyone is able to import the data from different datasets?
Could you provide the steps?
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
This is possible now by using composite models.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
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
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
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.
I found the answer, its a known issue:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.