Forum Discussion

ankesh's avatar
ankesh
Frequent Visitor
4 years ago
Solved

Add two different credentials for same data source in Power BI Service

I have two reports in two different workspaces which use PowerPlatformDataflows data source. Both have different credentials that I need to use because both are in different microsoft tenants but credentials for this source from one report automatically applies the same in the report in the other workspace as well and vice versa.

 

Since the reports are in different workspaces, I think Power BI should let me have two different credentials but isn't. Is there any other alternative for this? Any help is appreciated.

  • Hi ankesh ,

     

    In my test, I found that you had to use another account to take over the dataset in one of the workspaces so that you could set different credentials for the two datasets.

     

    Here are some screenshots of my test.

     

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support

    Hi ankesh ,

     

    In my test, I found that you had to use another account to take over the dataset in one of the workspaces so that you could set different credentials for the two datasets.

     

    Here are some screenshots of my test.

     

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hi ankesh 

     

    As it stands today it will use the same data source credential for the same dataflow. You would have to duplicate it and give it another name.

     

    You can vote for an idea here at https://ideas.powerbi.com

    • ankesh's avatar
      ankesh
      Frequent Visitor

      How do i give another name for "PowerPlatformDataflows" in both workspaces so that they are not considered the same? I am sorry if you misunderstood the question. I have edited it now to provide more clarity.