Editing queries - please assist

[Yolandi]

How do you change your queries to access a new table?

I have 1 sales report created (page 1) which I have duplicated.  Now the question, page 2 needs to query a different table?

The Edit Queries on the Power BI desktop app is greyed out...

[v-juanli-msft · Accepted solution]

Hi @Yolandi 

If you connect to data source via "Get data", then you could connect to another data source via "Get data" again.

"I have 1 sales report created (page 1) which I have duplicated"

What's the meaning?

you copy a pbix file from another pbix file, right?

"The Edit Queries on the Power BI desktop app is greyed out"

When the connection typy is Live connection, Edit Queries is greyed out.

Share me with the connection typy and data source.

you could open data source setting to see it.

Based on my understanding, you connect to SSAS with Live connection, then you want to connect to another table in the same pbix file, right?

If so, use "Get data"->SSAS connector->enter SSAS instance and credential

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @Yolandi 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Yolandi 

If you connect to data source via "Get data", then you could connect to another data source via "Get data" again.

"I have 1 sales report created (page 1) which I have duplicated"

What's the meaning?

you copy a pbix file from another pbix file, right?

"The Edit Queries on the Power BI desktop app is greyed out"

When the connection typy is Live connection, Edit Queries is greyed out.

Share me with the connection typy and data source.

you could open data source setting to see it.

Based on my understanding, you connect to SSAS with Live connection, then you want to connect to another table in the same pbix file, right?

If so, use "Get data"->SSAS connector->enter SSAS instance and credential

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.