cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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..

 

Capture.PNG

10 REPLIES 10
Highlighted
Super User III
Super User III

Re: Error get data from SQL server

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)


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Helper IV
Helper IV

Re: Error get data from SQL server

Hi @TomMartens,

 

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

I'm used import button.

Highlighted
Memorable Member
Memorable Member

Re: Error get data from SQL server

Hi @melina,

 

Try running Power BI Desktop as administrator and then check.

 

Prateek Raina

Highlighted
Helper IV
Helper IV

Re: Error get data from SQL server

hi @prateekraina,

 

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

Highlighted
Memorable Member
Memorable Member

Re: Error get data from SQL server

 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.

 

Solution1.PNG

 

Prateek Raina

Highlighted
Helper IV
Helper IV

Re: Error get data from SQL server

Capture.PNG

 Hi @prateekraina,

 

Why i only have just 2 folders?

Highlighted
Memorable Member
Memorable Member

Re: Error get data from SQL server

Hi @melina,

 

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

 

If still issue persists, try reinstalling Power BI Desktop.

 

Prateek Raina

Highlighted
Helper IV
Helper IV

Re: Error get data from SQL server

hi,

 

Anyone have idea?

I'm still cannot get data from sql server.

Highlighted
Helper IV
Helper IV

Re: Error get data from SQL server

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?

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors