The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
One of the datasources in my desktop report is using excel file from a shared location which I have access to. If I want to store some common account credentials to access that excel file, I cannot edit permissions for this excel file from the datasource settings. I am able to edit permission for all other datsources like sql, sharepoint. Is there a way to store credentials in pbix file for accessing the excel file from that shared path?
Solved! Go to Solution.
Hi @prasa,
Yes, when using SQL Server datasource, Power BI desktop will ask for a credential. However, it is not sotred in pbix file. The credential for the data source are stored on the machine which have the .pbix created C:\Users\<user name>\AppData\Local\Microsoft\Power BI Desktop\User.zip.
So yes. It is the case with all datasource not just Excel.
Reference: https://community.powerbi.com/t5/Desktop/Query-Editor-requires-credentials/td-p/164515
Thanks,
Xi Jin.
Is it the case with any datasource or just excel? I see an option to input database credentials for sql datasource. Will it not be saved in the file?
Hi @prasa,
Yes, when using SQL Server datasource, Power BI desktop will ask for a credential. However, it is not sotred in pbix file. The credential for the data source are stored on the machine which have the .pbix created C:\Users\<user name>\AppData\Local\Microsoft\Power BI Desktop\User.zip.
So yes. It is the case with all datasource not just Excel.
Reference: https://community.powerbi.com/t5/Desktop/Query-Editor-requires-credentials/td-p/164515
Thanks,
Xi Jin.
I need to update the credentials, however, I can only find The credential for the data source are stored on the machine which have the .pbix created C:\Users\<user name>\AppData\Local\Microsoft\Power BI Desktop\,
the "User.zip" folder is not found. @v-xjiin-msft
Okay got it. Thank you.
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
62 | |
53 | |
51 |