Forum Discussion

Rik91's avatar
Rik91
Regular Visitor
5 years ago
Solved

Building reports on third-party dataset

Hello Power BI family, I try to post a question here but I'm not sure if a solution exists. I'm trying to design a complex architecture for a customer this are the requirements: - there're 2 parts...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    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.

     

     

_sfrost's avatar
_sfrost
Solution Specialist
5 years ago

Rik91 

I believe we can acheive this with Dataflows. Haven't tried it tho, just a thought!

Dataflows allows you to use someone else credentials while connecting in Power BI Desktop. 

Source: Configure and consume a dataflow - Power BI | Microsoft Docs

 

By leveraging this, may be we can acheive your requirement!

 

Did you find my answer helpful? Please accept this as solution!

Rik91's avatar
Rik91
Regular Visitor
5 years ago

thanks _sfrost for the answer but it doesn't cover my scenario because using dataflows I would have to connect to all datasources in Tenant B from Tenant A and building a new model. the aim is to fully reuse the existing one on tenat B.

 

Another option I have could be Power BI Embedded solution. One custom App that encapsulate power bi embedded on tenant A and on tenant B. May it work?

  • _sfrost's avatar
    _sfrost
    Solution Specialist
    5 years ago

    You should be able to apply all kind of transformations on the Service itself, while creating the dataflow. You can simply connect to it from Desktop and build the report. Unless you are using any transformations that are not supported in Power Query Online.

     

    I'm afraid I am not sure about the embedded approach! May be someone else can answer.