Add gdb or shp file into Power BI just like in tableau

[paulpro123]

Hello, In tableau, It can add directly an GDB file or SHP file, is that available in power BI?

[foodd]

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.

Issues

If you have found a true bug or issue, you can make a post to the forum to let others know (and that would be very nice of you to do so). But if you want to get it fixed, you should post it in the Issues/Ideas (it varies) area of the community. Specifically, you should post it here:

Power BI - https://community.powerbi.com/t5/Issues/idb-p/Issues
PowerAutomate - https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound
PowerApps - https://ideas.powerapps.com


Ideas

If you have a new idea for functionality or how something should work, you can certainly start a thread on the community to solicit feedback on your idea, but you should also post the idea in the ideas section of the website and solicit others to vote on your idea. The development teams use the Ideas area of the communities to build their development pipeline and a significant amount of weight is placed on Ideas that have lots of votes versus those that do not. The ideas areas of the communities are here:

Power BI - https://ideas.powerbi.com
PowerAutomate - https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
PowerApps - https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[paulpro123]

I can't use mapshaper coz it's online. we can't just upload our data online.

[foodd · Accepted solution]

The point is that as a report maker, you can utilize various commercial or non-commercial options to extract the underlying data in a shape file. You can then present this data in different ways using multiple toolsets, especially the Shape Map Visualizations of Power BI.

Shape map visuals are based on maps that you can find on the Internet, create yourself, or convert to the TopoJSON format.

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

---

---

Another open-source option is to utilize any available toolset that meets your business requirements to transform and extract the graphical data into a structured XML document. Power Query can effortlessly import the data into Excel or Power BI Desktop at this stage.

---

@paulpro123 wrote:

I can't use mapshaper coz it's online. we can't just upload our data online.

---