Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.