Forum Discussion

tphc1979's avatar
tphc1979
Copper Contributor
Dec 18, 2023

query 2 workspaces from power bi

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?

 

  • 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?

     

     

    • tphc1979's avatar
      tphc1979
      Copper Contributor
      i9so having s separate query for each workspace?

Resources