Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
djparkinson
New Member

Using Power BI to create an online directory of services

Hi

 

I am looking for examples of using Power BI to create an online searchable directory of services using a published map where people can look in their geographical area and the results show what support services are available in their area.

 

Hope that makes sense!


Diana

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @djparkinson ,

Below is my table:

vxiandatmsft_0-1699854325361.png

You can try the steps below to complete the map online searchable service:

1.data preparation

Gather information about the support services available in your area. This may include details such as the service name, description, contact information, and geographic coordinates (latitude and longitude).Organize this data in a structured format, such as Excel, CSV, or a database.

2.To create a Power BI report:

Open Power BI Desktop.Import a data source, such as an Excel file, into Power BI.Design your report by adding visuals, including map visuals that leverage geographic coordinates.Use the Location, Latitude, and Longitude fields to create map visualizations1.Customize the map to display relevant information (for example, service name, icon, or other details).

3Publish to the web:

When your report is ready, use the Publish to web feature in Power BI to publish it to Web.This will generate a unique URL for the report that can be shared publicly.

4Embed a map on your website:

Embed the published map URL on a website or portal that users can visit.Users can now search for services in their geographic area by interacting with the map.The results will show the available support services, making it easy for people to find relevant resources.

vxiandatmsft_1-1699854342972.png

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @djparkinson ,

Below is my table:

vxiandatmsft_0-1699854325361.png

You can try the steps below to complete the map online searchable service:

1.data preparation

Gather information about the support services available in your area. This may include details such as the service name, description, contact information, and geographic coordinates (latitude and longitude).Organize this data in a structured format, such as Excel, CSV, or a database.

2.To create a Power BI report:

Open Power BI Desktop.Import a data source, such as an Excel file, into Power BI.Design your report by adding visuals, including map visuals that leverage geographic coordinates.Use the Location, Latitude, and Longitude fields to create map visualizations1.Customize the map to display relevant information (for example, service name, icon, or other details).

3Publish to the web:

When your report is ready, use the Publish to web feature in Power BI to publish it to Web.This will generate a unique URL for the report that can be shared publicly.

4Embed a map on your website:

Embed the published map URL on a website or portal that users can visit.Users can now search for services in their geographic area by interacting with the map.The results will show the available support services, making it easy for people to find relevant resources.

vxiandatmsft_1-1699854342972.png

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.