Forum Discussion
mussol_
Advocate II
Advocate IITWO 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...
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_Advocate II
Advocate IIHello 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
Resident Rockstar
Resident RockstarHi 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