Forum Discussion

melina's avatar
melina
Icon for Helper IV rankHelper IV
9 years ago

Error get data from SQL server

Hi All,   I had received error when i want to get data from SQL Server. Kindly need your help to advise..  
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

Can you please describe when you get the error message

  • Opening the Power BI File
  • Do you have administrative rights on the machine where you get the error
  • Opening a Report
  • Is there a Direct Query Connection
  • Trying to connect to the SQL Server instance (where is the instance located: on your machine, on-premises, or somewhere in the cloud)
melina's avatar
melina
Icon for Helper IV rankHelper IV
9 years ago

Hi TomMartens,

 

I got this kind of error when i use get data from SQL Server database.

I'm used import button.

  • prateekraina's avatar
    prateekraina
    Icon for Memorable Member rankMemorable Member
    9 years ago

    Hi melina,

     

    Try running Power BI Desktop as administrator and then check.

     

    Prateek Raina

    • melina's avatar
      melina
      Icon for Helper IV rankHelper IV
      9 years ago

      hi prateekraina,

       

      Done running as administrator but still pop up the same error as picture above.

      • prateekraina's avatar
        prateekraina
        Icon for Memorable Member rankMemorable Member
        9 years ago

         Hi melina,

         

        Issue has got to be with your machine related to security/permissions.
        Check below screenshot and see whether you hold permission to access this cache.key file.

         

         

        Prateek Raina