Forum Discussion

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable 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

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

Thank you for the reply.

 

I definitely can understand that one cannot refresh without the credentials in this scenario. 

 

But the restriction of opening the Query Editor does not seem a correct design.  There is no inherent linking needed/done to the data source when manipulating/modeling imported data (as I understand) as this is not a Direct Query scenario.

 

I think many of us that are mobile need to take a pbix file with us and refine the modeling when working in another location - ultimately returning that pbix file to its original location for the linking/refresh. 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity 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
    Icon for Memorable Member rankMemorable 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
      Icon for Community Support rankCommunity 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
        Icon for Helper I rankHelper 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?