multiple queries for same table

[Brighton10]

Hi everyone

I have a table named table1. I have 3 report pages querying the same table but with different queries for example

page1 relies on:

select firstname, lastname, salary

from table1

where departmentName = 'IT'

page 2 relies on:

with maxSalary as(

select max(salary) over(partition by departmentName order by salary) maxSal

from table1)

select * from maxSalary where salary = maxSal

page 3 relies:

select count(userId), departmentName

from table1

group by departmentName

N.B These queries are just for demo purposes and can be complex that you cannot combine them in one query.

Is there a way to read from the same table without having to write 3 separate queries as the table will be loaded 3 times when refreshing which might not be favourable for perfomance? Will the concept of shared datasets work here? Thanks for your help in advance.

[v-xiaosun-msft]

Hi @Brighton10 ,

A shared dataset is a dataset that is used in more than one report at the same time. 

According to your description, it seems that what you need is to try three queries at the same time in one report. Maybe you need some external programs where you can at least export all your queries into one file.

Please reference the following links.

Power BI Datamart Vs Dataflow Vs Shared Dataset | 2022 (podiumbi.com)

Edit multiple queries at the same time - Microsoft Power BI Community

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.