query 2 workspaces from power bi

Copper Contributor

I have a gqkl query that is s union of 2 workspaces  this runs and I get expected data when I export the query to m language and run from a psi dataflow I get ab authentication error against the second workspace   the creds I'm using in pbi  are for the First workspace.   can this even be done or is there a more robust method?

 

2 Replies

Hey @tphc1979 

 

Have you thought about authenicating to the second workspace within PowerBI using a seperate M query rather then using a cross workspace query from a single workspace?

 

 

i9so having s separate query for each workspace?