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 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's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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