TWO PATHS FOR MS ACCESS ORIGIN

[mussol_]

Hello everybody,

I need two different paths for an MS Access data base.

Actually I have one working fine with the following PQ instruction for origin:

= OleDb.DataSource("provider=Microsoft.ACE.OLEDB.12.0;data source=""X:\PROFESIONAL\CUSTOMER\MANTENIMIENTO\GMAO - Access\GepmesterPlusz.mdb"";jet oledb:system database=""X:\PROFESIONAL\CUSTOMER\MANTENIMIENTO\GMAO - Access\SysGm.mdw""")

But my customer has another path and I want to select with a parameter (as it works with MS Excel Files, for example). If I try the same way (just replacing path for the name of the parameter) it does not work.

Can somebody help me with this?

Many thanks in advance.

Josep.

[v-piga-msft · Accepted solution]

Hi @mussol_ ,

It seems that you use ODBC connector to get data from Microsoft Access database.

Normally, we could use query parameter to change the data source, but the data model and the data type should be the same.

What about your data structure of the two data source?

In addition, you could try with the direct connector for MS Access database in power bi desktop.

Best  Regards

Cherry

[mussol_]

Hello Again,

I tried to load the access DB with PBI access connector but all tables appear as empty.

I think the file SysGm.mdw is related with this.

Any other sugestion?

Thanks a lot!

Josep. 

[v-piga-msft]

Hi @mussol_ ,

It's really strange for that.

You could use ODBC connector and change the data source with query parameter as I suggested in my first reply.

Best  Regards,

Cherry

[mussol_]

Hello V-piga-msft

Yes, I am using ODBC connector because acces DB has passwords and users...

I will try your solution and explain.

Thanks a lot!

Josep