Forum Discussion
Windows 10, Power BI x64, Postgresql 9.6 and Maps
Hi jmamuedo,
I tested the 32 bits version of Power BI and I could connect to my Database. But I would like to know if is possible to do the same in x64 version.
Power BI Desktop x64 version does support postgresql database. In my test, I installed Npgsql 3.25 and I selected the option to install to the GAC during the installation process. After installing, I restarted Power BI desktop, the prompt message that it requires the Npgsql component disappeared and I could connect to PostgreSQL.
How to make a maps with postgresql data.
How can I relate my table from Postgresql and my Shape Map (json)?
Did you want to create a map based on data retrieved from PostgreSQL DB? If so, how did your table view look like? But you said Shape Map json, did you mean the usage of custom map? I could not understand your last question.
Regards,
Yuliana Gu
Microsoft EmployeeHi jmamuedo,
I tested the 32 bits version of Power BI and I could connect to my Database. But I would like to know if is possible to do the same in x64 version.
Power BI Desktop x64 version does support postgresql database. In my test, I installed Npgsql 3.25 and I selected the option to install to the GAC during the installation process. After installing, I restarted Power BI desktop, the prompt message that it requires the Npgsql component disappeared and I could connect to PostgreSQL.
How to make a maps with postgresql data.
How can I relate my table from Postgresql and my Shape Map (json)?
Did you want to create a map based on data retrieved from PostgreSQL DB? If so, how did your table view look like? But you said Shape Map json, did you mean the usage of custom map? I could not understand your last question.
Regards,
Yuliana Gu
Hi v-yulgu-msft,
Thanks for your response.
I followed every steps you indicate me and I can connect correctly with Postgresql.
About the last question I mean if it is possible to connect to Postgis to get object with 'geom' field or if there are another way to create spatial info. I say that because for each map I need to create a new Topojson and reporject my data to WGS84. I am looking for another option to work authomatic way and to obtain a integral data structure . That means that all my data can be refresh together.
Thanks again.
