Forum Discussion
tphc1979
Dec 18, 2023Copper Contributor
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?
- BillClarksonAntillIron Contributor
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?
- tphc1979Copper Contributori9so having s separate query for each workspace?