Forum Discussion
Query Editor requires credentials?
Hi CahabaData,
I got the information from PG that
The query editor cannot read the data stored in the data model. Even if it could, the data in the data model represents the output of the very last step and the query editor wants to be able to show partial output for intermediate steps. That data is never loaded into the data model.
No passwords are stored in the 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.
Best Regards,
Qiuyun Yu
Hi CahabaData,
I got the information from PG that
The query editor cannot read the data stored in the data model. Even if it could, the data in the data model represents the output of the very last step and the query editor wants to be able to show partial output for intermediate steps. That data is never loaded into the data model.
No passwords are stored in the 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.
Best Regards,
Qiuyun Yu
I tried to copy the user.zip to a different computer which runs the same pbix file, so they can refresh the data.
I don't want to share the actual credentials values with other users.
Still it asks for the database credentials for resfreshing the data.
What do I miss here?
Database: sql server
Power BI desktop : Version: 2.82.5858.1161 64-bit (June 2020)
Best guess: the credentials.bin file inside the zip is encrypted with either a certificate or stored value (perhaps in the credential manager) on the source computer and that key does not exist on the "different computer" you moved the zip to.
