Forum Discussion

CahabaData's avatar
CahabaData
Memorable Member
9 years ago
Solved

Query Editor requires credentials?

the pbix file is set up Get Data from SQL Server Views   all working fine, has been set up for awhile and refreshed several times....no problems   I took the pbix to a different computer and work...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi CahabaData,

 

I have sent a email to consult this scenario internally, will update to you if get feedback.

 

Best Regards,
Qiuyun Yu

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

Thank you for that update - I appreciate your follow through.  I think this issue will be key to the user community.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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

    • CLEARIFY's avatar
      CLEARIFY
      Helper I
      8 years ago

      Is this true even when the credentials in the ODBC driver are already there?  PowevPivot doesnt' request it, but Power BI does?

    • CahabaData's avatar
      CahabaData
      Memorable Member
      9 years ago

      thank you that is a very interesting clarification of the architecture

       

    • farbodfbr's avatar
      farbodfbr
      Regular Visitor
      5 years ago

      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)

      • ioamnesia's avatar
        ioamnesia
        Regular Visitor
        5 years ago

        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.