cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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.

All files seem to use whatever the last credentials are.

 

Is there a way to force the credentials to be saved with each file as i need to update them every time i open a new file to make sure the correct data is brought back.

 

Any ideas?

5 REPLIES 5
Super User IV
Super User IV

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Frequent Visitor

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.

@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. 

datasource setting.JPG

 

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.

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.

@GRob- any solution to this? I'm having the same issue, only difference being I'm using a dataflow to connect to an API.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors