Error get data from SQL server

[melina]

Hi All,

I had received error when i want to get data from SQL Server.

Kindly need your help to advise..

[TomMartens]

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]

Hi @TomMartens,

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

I'm used import button.

[prateekraina]

Hi @melina,

Try running Power BI Desktop as administrator and then check.

Prateek Raina

[melina]

hi @prateekraina,

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

[prateekraina]

 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

[melina]

 Hi @prateekraina,

Why i only have just 2 folders?

[prateekraina]

Hi @melina,

No idea about that buddy. Try clearing your cache as shown in below screenshot and then try:

If still issue persists, try reinstalling Power BI Desktop.

Prateek Raina

[melina]

hi,

Anyone have idea?

I'm still cannot get data from sql server.

[melina]

Hi @prateekrain

The reasons i does not have Cache.Key file it is because of i'm using trial version power bi desktop?

I'm still dont get the way on how to get data from SQL server?..It is any other alternative way?

[prateekraina]

Hi @melina,

Please install Power BI desktop latest version from here and give it a try.

Prateek Raina