topic Re: Load GeoJson Map to capabilities.json in Developer

Load GeoJson Map to capabilities.json

Anonymous — Fri, 02 Jun 2017 08:19:39 GMT

Hello,

I'm currently developing a custom visual, so I'm looking to load a geojson map through capabilities.json. My question is: how can I achieve that ? Shall I just consider the map as measure ?

Thank you,

Re: Load GeoJson Map to capabilities.json

v-chuncz-msft — Mon, 05 Jun 2017 10:08:09 GMT

@Anonymous,

You may do research into objects in API https://github.com/Microsoft/PowerBI-visuals-tools/blob/master/templates/visuals/.api/v1.6.0/schema.capabilities.json. Also check if a Shape Map visual could be an alternative.

Re: Load GeoJson Map to capabilities.json

Anonymous — Tue, 06 Jun 2017 12:58:01 GMT

Shape file could be an alternative but is its source code available for developement ? In Fact I'm looking to load a geojson map and display it using d3 Library .. But I don't know how to load the json file.

Re: Load GeoJson Map to capabilities.json

v-viig — Wed, 07 Jun 2017 09:27:11 GMT

Hello @Anonymous

Do you want to load json file from local computer or do you want to save it using Power BI Data sets?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Wed, 07 Jun 2017 13:47:14 GMT

Either way, for now, I just want to display a custom map. So it can either be load from a local file, or through a drap and drop via Power BI.

Thank you for your help 🙂

Re: Load GeoJson Map to capabilities.json

v-viig — Thu, 08 Jun 2017 08:34:02 GMT

@Anonymous,

You might load local file using FileReader.

Please feel free to ask us any questions about custom visual development.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Thu, 08 Jun 2017 08:41:08 GMT

Thank you for you response. I'm talking about loading a file within a custom visual and not a web page. Apparently, I should use an object within capabilities but I don't know which one.

Re: Load GeoJson Map to capabilities.json

v-viig — Fri, 09 Jun 2017 17:55:41 GMT

@Anonymous,

I'm not sure that understand your case well.

Do you want to upload and save a file in Power BI? Is that correct?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Sun, 11 Jun 2017 20:40:38 GMT

I'm developing a custom visual that is displaying a shape map.

I want to know how I can upload the .geojson map into my custom visual.

In other words, how I can upload a file into my custom visual. I know that I can achieve that through defining an object in capabilities.json file. but I don't know how.

Re: Load GeoJson Map to capabilities.json

v-viig — Tue, 13 Jun 2017 13:20:34 GMT

@Anonymous

Just to make sure that my understaning is correct.

You want to have an ability to load a file by using the format panel. Is that correct?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Tue, 13 Jun 2017 13:30:46 GMT

@v-viig exactly, I want to load a geojson or json file through the format panel, to define the polygons of my map.

Re: Load GeoJson Map to capabilities.json

v-viig — Thu, 15 Jun 2017 15:13:09 GMT

@Anonymous,

That's impossible right now. Power BI Custom Visuals API doesn't implement an ability to support loading file using formatting panel.

As a workaround, you should implement your own JavaScript code that handles loading files.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Thu, 15 Jun 2017 15:28:21 GMT

@v-viig thank you for your answer

so what are the alternatives shall I load my map from external ressource with https ? is there any alternative ? Can I load the map from the field pane ? There is already a visual (Shape map) that uses loading through Format Pane. isn't it possible for everybody ? Can't I simply include my map as a js code inside the dependance node_modules and include it in pbiviz.json ?

Re: Load GeoJson Map to capabilities.json

v-viig — Thu, 15 Jun 2017 15:34:33 GMT

It isn't possible for custom visuals unfortunately.

There're a few options:

Load it from an external resource that uses HTTPS
Keep maps in Power BI data-set and then apply data to the visual. The data would be avialable in the update method
You can use JS File API to load from local device/PC
Keep it in an external JS and include into pbiviz.json

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Thu, 15 Jun 2017 17:09:46 GMT

@v-viig

You can use JS File API to load from local device/PC

This option, how does it work ?
Keep it in an external JS and include into pbiviz.json

Exactly I was thinking of this one, I tried it but it doesnt work. I stored the map data as a variable in a file map.js. I referenced it in pbiviz.json. And I use the variable in Main.ts file. But It couldn't find the variable.

Re: Load GeoJson Map to capabilities.json

v-viig — Fri, 16 Jun 2017 13:18:07 GMT

Please take a look at FileReader to find out more about File API.

How did you try to access the variable? What errors did you get?

I suppose that you should use window["variableName"] to find it. Another option is to declare the varaible in TypeScript in order to get rid of type checking errors.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Fri, 16 Jun 2017 15:09:52 GMT

@v-viig I tried to access the variable directly but it couldn't find it, I referenced it in pbiviz.json .

I have another problem with the organization of my code. I only instanciated the map in the constructor, and handled everything else in the update method. How should I organize my code is it kind of MVC ?

Re: Load GeoJson Map to capabilities.json

v-viig — Mon, 19 Jun 2017 14:55:48 GMT

Are you able to share the code that tries to access a varaible?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Load GeoJson Map to capabilities.json

Anonymous — Fri, 22 Sep 2017 14:12:52 GMT

@v-viig I'm wondering how I can store a geojson file as Power Bi dataset and call it in Data view. Do you have any example doing same thing ? What I did I stored the geojson data set as a string in a table. and then I make an outer join with the dataset containing data. so that each time I get the geojson and dataset.

Re: Load GeoJson Map to capabilities.json

v-viig — Mon, 25 Sep 2017 09:23:50 GMT

If you want to store geojson as a PBI dataset you should store geojson as a string in your table.

Another option is to implement improting geojson by using File JS API and store it as a property of formating panel.

Please let me know if you have any questions.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com