Forum Discussion

mussol_'s avatar
mussol_
Advocate II
7 years ago
Solved

TWO PATHS FOR MS ACCESS ORIGIN

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...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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_'s avatar
mussol_
Advocate II
7 years ago

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