2 Dataflow sources listed, only want 1

[Curtiosity]

I have a report that was initially pointing to dataflows in the workspace "Finance & Auxiliary Services Team Sandbox".  With the help of a consultant, it was changed to point to dataflows with the same naming conventions in the workspace "Finance Semantic Models".  I think how that was accomplished was by using the Advanced Editor and changing the values for the workspaceID and dataflowID.

When I go into Power Query from the desktop version of Power BI, these screenshots show what is there.  It is listing both workspaces. 

How can I remove the "Finance & Auxiliary Services Team Sandbox" workspace from the listing?

It seems like the source being = PowerBI.Dataflows(null) is wrong - shouldn't it have a name there?

And why does the Filtered Rows step use Transactions_Fact1 instead of Transactions_Fact which is the name of my table?  At some point in changing the dataflow source, we may have copied the Transactions_Fact table to Transactions_Fact1 and then deleted it, I can't remember for sure.

This is from the Advanced Editor:
let
Source = PowerBI.Dataflows(null),
#"8d704e97-efed-4948-a89b-a8a9028d3dd3" = Source{[workspaceId="8d704e97-efed-4948-a89b-a8a9028d3dd3"]}[Data],
#"844ff821-0dbf-4e71-bc2a-94a459bab356" = #"8d704e97-efed-4948-a89b-a8a9028d3dd3"{[dataflowId="844ff821-0dbf-4e71-bc2a-94a459bab356"]}[Data],
Transactions_Fact1 = #"844ff821-0dbf-4e71-bc2a-94a459bab356"{[entity="Transactions_Fact"]}[Data],
#"Filtered Rows" = Table.SelectRows(Transactions_Fact1, each ([DEPT_EXCLUDE] = "N")),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"FISCAL_YEAR", Order.Ascending}})
in
#"Sorted Rows"

Thanks,

Wendy

[Curtiosity]

I solved my problems - not currently seeking any answers.  Thanks.

[pankajnamekar25]

Hello @Curtiosity 

Try this

let

    // Connect only to the correct workspace

    Source = PowerBI.Dataflows([workspaceId="8d704e97-efed-4948-a89b-aa89028d3dd3"]),

    // Access the specific dataflow and entity

    Dataflow = Source{[dataflowId="844ff821-0dbf-4e71-bc2a-94a459bab356"]}[Data],

    Transactions_Fact = Dataflow{[entity="Transactions_Fact"]}[Data],

    // Apply filter

    FilteredRows = Table.SelectRows(Transactions_Fact, each ([DEPT_EXCLUDE] = "N")),

    // Sort the data

    SortedRows = Table.Sort(FilteredRows, {{"FISCAL_YEAR", Order.Ascending}})

in

    SortedRows

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Curtiosity · Accepted solution]

Thanks.  I tried this and got:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
dataflowId=844ff821-0dbf-4e71-bc2a-94a459bab356
Table=[Table]

I had been trying to use Copilot to help me figure this out earlier.  I finally asked the question in a better way and found out this meaning.
let
    Source = PowerBI.Dataflows(null),
Purpose: Connects to all Power BI Dataflows available to your account.
Note: null means it uses the default environment (your current Power BI service context).

I tried a different fix and got an error and when following the go to error button it let me navigate to the dataflow I wanted to use and I chose it and it rewrote the content of the advanced editor back to the way it originally was.  I'll do some looking around in the dataflows and see if that is where the Transactions_Fact1 is coming from.

In any case, I had started looking at this because it wasn't refreshing properly, but it is working now.  

[v-dineshya]

Hi @Curtiosity ,

Thank you for reaching out to the Microsoft Community Forum.

If your issue is resolved , please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @Curtiosity ,

Thank you for reaching out to the Microsoft Community Forum.

If your issue is resolved , please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found that response helpful.

Thank you

[v-dineshya]

Hi @Curtiosity ,

Thank you for reaching out to the Microsoft Community Forum.

If your issue is resolved , please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found that response helpful.

Thank you

[Curtiosity]

I'm not sure why you keep sending the same message.  I had one response and it didn't resolve my issue. 

[v-dineshya]

Hi @Curtiosity ,

I apologize for the issue causing. 

Please follow below below steps.

1. Created sample based on your inputs, Refer snap.

2.  Created M code, please refer below 

let
Source = PowerBI.Dataflows([workspaceId="8d704e97-efed-4948-a89b-a8a9028d3dd3"]),

Dataflow = Source{[dataflowId="844ff821-0dbf-4e71-bc2a-94a459bab356"]}[Data],

Transactions_Fact = Dataflow{[entity="Transactions_Fact"]}[Data],

#"Filtered Rows" = Table.SelectRows(Transactions_Fact, each ([DEPT_EXCLUDE] = "N")),

#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"FISCAL_YEAR", Order.Ascending}})
in
#"Sorted Rows"

3.  when i tried to execute the M code, Please refer below snap.

Code is working fine, but check the below things.

In Power Query, Click on edit credentials and navigation to reconnect to the correct dataflow, And resolve the refresh issue.

If the Refresh Fails Again, try the following checks:

1. Re-authenticate Power BI service permissions in Power Query (Data source settings → Edit Permissions).
2. Ensure the workspace/dataflow still exists and your account has access.
3. Check if parameters are being used (sometimes a null or ID gets reset).

Please refer the sample PBIX file for your reference.

If the above information is helpful, please give us "Kudos " and mark the response as "Accepted as solution".

Best Regards,

Dinesh

[Curtiosity]

If you'll read the response I did to the other person that first replied to me, I discovered why 2 dataflows were showing.  I'm not currently looking for more answers.  I have no idea how your solution got marked as the correct reponse - I did not do that.  You did not give a correct response.

It seems like you are just incessantly posting to this to try to boost your ratings or something.  If you gave me a helpful answer, I'd mark it.  Please quit asking me to mark your solutions.

[v-dineshya]

Hi @Curtiosity ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.