Forum Discussion
Displaying multiple reports on one screen
I have 3 reports which use direct query to get data from 3 different databases. I want to see all 3 reports on the same page so we can compare the results from the 3 databases.
This is easy if I import the data but as the datasets are so big it takes more than 5 minutes to produce the 3 sets of data and then the visualisations.
If I use direct query the individual reports are almost instantanious.
I thought a dashboard might be the answer but as at the moment I am using desktop it doesn't seem that will work for me.
Does anyone have any ideas on what I can do please?
The reality is I started from scratch and resolved this myself by adding the SQL query at the beginning when creating the connection to reduce the data set being imported.
4 Replies
sallywt wrote:
I have 3 reports which use direct query to get data from 3 different databases. I want to see all 3 reports on the same page so we can compare the results from the 3 databases.
This is easy if I import the data but as the datasets are so big it takes more than 5 minutes to produce the 3 sets of data and then the visualisations.
If I use direct query the individual reports are almost instantanious.
I thought a dashboard might be the answer but as at the moment I am using desktop it doesn't seem that will work for me.
Does anyone have any ideas on what I can do please?
Yes, in a dashboard, you can pin live pages. As to Power BI desktop, I don't it is to do more things than developing reports. Maybe you can apply filter to queries to narrow down datasize in import mode.
By the way, what you're going to do with that report in PBI desktop? You can publish it to "myworkspace" in Power BI Service and create a dashboard.
I don't get an option to amend the query when importing the data so it always tries to import everything and then do the necessary filtering of the data for the report unless I do a direct query.
The reality is that this needs to be almost a real time report so we can see that our orders are being passed across the 3 databases that they need to be fed into.
The reality is I started from scratch and resolved this myself by adding the SQL query at the beginning when creating the connection to reduce the data set being imported.
