Forum Discussion
Building reports on third-party dataset
- 5 years ago
Hi Rik91
The datasets and workspaces allowed published are had linked to the currently signed in user. Therefore, you can't directly connect the datasets of another tenant. Dataflow is different from it. No matter what user is currently logged in, the cached credentials will be used. Compare to your other workarounds, dataflow is more feasible. For more details, you can refer Connect to Power BI dataflows and datasets using Power BI Desktop with multiple accounts.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I got in contact directly with Microsoft trough a colleague of mine that's MVP and they confirmed that using a dataset from a different tenant is simply unsupported. I think dataflows could be a good workaround to extract data from tenant B and moving them to tenant A maybe using an organizational Azure Data Lake Storage in order to move them where needed using something like ADF.