Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Geodatabase file .gdb

Hi everyone - I need help connecting my Geodatabase Data to Power BI. I have the Geodatabase file(.gdb) in my computer but I can't open it with Power BI, I tried to use the folder import method but it didn't. So I was wondering if there's another way to connect my geodatabase to Power Bi. 

Thank you

Need Help

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

     

    Based on my research, geodatabase is a collection of geographic datasets of various types held in a common file system folder, or a multiuser relational database management system (such as Oracle, Microsoft SQL Server, PostgreSQL, IBM Informix, or IBM Db2). You could directlt connect to these database like SQL Server, IBM Db2 from Power BI desktop. Alternatively, you could export data into XML file which is a supported file type by Power BI desktop. 

     

    Best regards,

    Yuliana Gu

  • Flamas's avatar
    Flamas
    Regular Visitor
    5 years ago

    could you solve your problem based on the answer provided? if yes, please tell me how, I have the same question, but when using the SQL Server connector it asks me to have a server, but what I have in a database file .gdb

  • ERICCFG's avatar
    ERICCFG
    Frequent Visitor
    2 years ago

    Do you find a solution, i have the same problem

  • paulpro123's avatar
    paulpro123
    New Member
    2 years ago

    I have the same problem, please tell me if you have any ideas to do it

    • foodd's avatar
      foodd
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Create Shape Map visualizations in Power BI Desktop (preview)

      From <https://learn.microsoft.com/en-us/power-bi/visuals/desktop-shape-map>

       

      Power BI Desktop data sources listing (last updated 5/21/2024)

      With Power BI Desktop, you can connect to data from many different sources. For a full list of available data sources, see Power BI data sources.   

       

      Manage Shapefiles for ingestion to Power BI

      Tool:  Mapshaper

      Availability:  mapshaper.org

      Summary:  Mapshaper is software for editing Shapefile, GeoJSON, TopoJSON, KML, CSV, and several other data formats, written in JavaScript. Mapshaper supports essential map making tasks like simplifying shapes, editing attribute data, clipping, erasing, dissolving, filtering and more.  Files can be zipped or gzipped.  See the project wiki for documentation on how to use mapshaper.  To suggest improvements, add an issue.

    • ERICCFG's avatar
      ERICCFG
      Frequent Visitor
      2 years ago

      tu peux essayer avec ce filtre, il va chercher ta base de donnée GBD