Forum Discussion

GRob's avatar
GRob
Frequent Visitor
6 years ago

Web data source with different credentials not saving per file

I have multiple pbx files, each basically the same report, but each one calls the same web URL with different credentials. My problem is that each file doesn't save the credentials with the file. A...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

GRob that is tough one, weird scenario though. Not sure if you can save the multiple credentials for the same data source.

  • GRob's avatar
    GRob
    Frequent Visitor
    6 years ago

    I assume that the data source URL I used in the first pbix file is resused in other files if i decide to use the same url in another pbix file.

    So data sources are shared.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      GRob 

      Power Bi defaultly saves datasource credentials to the global permission list, it goes with your Power BI account. You can edit the permission in with different credentials in the Current file list. 

       

      Paul Zheng _ Community Support Team
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • GRob's avatar
        GRob
        Frequent Visitor
        6 years ago

        The problem that i have is that the web service returns data based on the credentials sent.

        E.g. username1 returns dataset1, usename2 returns dataset2.

         

        If I create 2 pbix files, one for username1, then another for username2 the datasource uses the last credentials used, not the credentials per pbix

        My problem would be solved if it saved credentials per pbix file.