Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
melina
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
TomMartens
Super User
Super User

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

Hi @TomMartens,

 

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

I'm used import button.

Hi @melina,

 

Try running Power BI Desktop as administrator and then check.

 

Prateek Raina

hi @prateekraina,

 

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

 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

Capture.PNG

 Hi @prateekraina,

 

Why i only have just 2 folders?

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

hi,

 

Anyone have idea?

I'm still cannot 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?

Hi @melina,

 

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

 

Prateek Raina

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.