cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

desktop.ini file

Good morning!

 

I seem to be having a new type problem in the power query refresh process - as I get an error indicating "Microsof ACE.OLEDB 12.0 provider is not registered on the local machine.   The 64 bit version of the Access Database engine 20110 Acces Database Endine OLEDB may be required to read desktop.ini.

 

Then as I debug and step thru queries, using Folder.Files() source function - I see reference to the desktop.ini file within the list of potential files.   Seems if I filter those out, the error goes away (at least on that query).  

 

Is anybody else experiencing this issue - and is there a easy solution, other than stepping thru each and every query (within multiple pbix files).   Yes, I wished I had utilized a function when I was first learning and establishing these queries...

 

I have tried a new computer - same problem, and 2) on a smaller/simpler pbix file, the refresh process works as expected - so I don't think it is a computer issue.   

 

thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: desktop.ini file

Hello - no, I went back to a differing pbix file (with completely different data sources, but still excel) and it worked fine.  That indicates it's not a computer/compatibility issue?

 

As I have researched, the desktop.ini file is a windows (hidden file) within each folder.   I have no idea, why this problem just popped up.   But, I have gone thru and within all import related queries, filtered out this file name, and all is well....

 

thanks for your suggestions!

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: desktop.ini file

Hi @Dellis81 ,

According to your error message, it seems like this issue more related to access database engines. Maybe you can take a look at following link about issues about use access database on power bi desktop:

Resolve issues importing Access and .XLS files in Power BI Desktop 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: desktop.ini file

Thank you for your response and link.   Yes, I have gone down the trail as suggested in the link - but did not resolve the problem.

 

I have been able to "move on", as I went thru each of my import queries and filtered out any reference to teh desktop.ini file.   But, this does not solve the problem on other pbix files, if this issue was to rise again.   This is a new issue - and not sure what caused it to pop up.   I've been using this pbix file for 6+ months now...

 

thanks again!

Highlighted
Community Support
Community Support

Re: desktop.ini file

HI @Dellis81 ,

So you mean your pbix file works on old version power bi desktop? What version of power bi desktop are you test? Can you please share some more detail information to help us clarify you scenario?

How to Get Your Question Answered Quickly  

In addition, if your software environment does not change on your device and it failed when you update power bi desktop. This issue may be related to the compatitily between power bi desktop and the data connector driver.
You can try to submit a support ticket for further support. (it is free for pro and above licenses)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: desktop.ini file

Hello - no, I went back to a differing pbix file (with completely different data sources, but still excel) and it worked fine.  That indicates it's not a computer/compatibility issue?

 

As I have researched, the desktop.ini file is a windows (hidden file) within each folder.   I have no idea, why this problem just popped up.   But, I have gone thru and within all import related queries, filtered out this file name, and all is well....

 

thanks for your suggestions!

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors