The provider 'Microsoft.Mashup.OleDb.1' is not registered

Receiving the error below when attempting to deploy package:

but still failed, got error message:  The provider 'Microsoft.Mashup.OleDb.1' is not registered.
The following system error occurred:  Class not registered
A connection could not be made to the data source with the DataSourceID of 'b0581e01-30d0-42fc-9ec5-33ed9fee4a2f', Name of 'Power Query - FactOshaLostTime'.
richa1960Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you provide us the full picture?
Starting by what are you trying to do.
sammySeltzerCommented:
What that error means is that you are trying to deploy an application that points an access DB with OLE data source that does not exist on the server you are deploying to.

So, you have two choices.

1, download will install a set of Oledb components Microsoft Access to the server you are deploying to.

2, or switch to access 2007 or later versions.

This versions use Ace data source.
Jessica WhitleySoftware DeveloperCommented:
I believe Sammy meant 2007 or earlier versions of access. They will have the Oledb components. Newer versions do not.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

richa1960Author Commented:
trying to find Oledb for access 2007.
sammySeltzerCommented:
Access 2007 to 2013 use ACE:

ACE.OLEDB.12.0...

Try installing the following on the server that needs it:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

This component includes what you are looing for, AccessDatabaseEngine.exe

Let us know what happens.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
richa1960, do you still need help with this question?
richa1960Author Commented:
I ended up applying all the solutions.
Dung DinhDBA and Business Intelligence DeveloperCommented:
As I know, Power Query does not support as data source. It means that you can not create a SSAS model if you use Power Query.

http://www.sqlchick.com/entries/2014/2/22/power-bi-error-provider-microsoftmashupoledb-is-not-registered

Here is an extra solution you can use:
- Build Power Query to extract data and save them to excel /csv data format
- Build a workbook with Power Pivot Data Model and receive the exce/csv files as data source
- Import Data Model into SSAS Tabular

Thanks,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.