Source = Excel.Workbook(Web.Contents(""), null, true),
The Advanced Editor will now open.Įnter the following code into the Advanced Editor: (you can copy and paste the code directly from this site) Click Done to load the data. Now you will be in the Query Editor, click on the View ribbon and select the Advanced Editor button. On the Home ribbon click on the Get Data button and from the Get Data window select Blank Query.
You can download the latest version of the software here. The version of PowerBI Desktop for this tutorial is .362 64-bit (September, 2016).
This tutorial will review how to load data using Latitude and Longitude data and map those points on the ArcGIS map.įirst, we need to open PowerBI Desktop and then we will load some data.
For more information on the maps integration you can read the following post from Microsoft.
I will check the feedback form at Microsoft to see if anyone's started a request to have ArcGIS work with PDF and if so I will vote it up.In the September 2016 release of PowerBI, Microsoft introduced a new visual called the ArcGIS Maps preview. There's a lot going on on the map beyond what would happen in a bar chart or table so it's understandable that it's complex. That does make me wonder what's different about this product as no other default visual needs to be treated in this manner. I'm guessing that to become a certified custom visual there are number of criteria and it makes sense to test them for PDF export compatibility.ĪrcGIS is built into PowerBI however you do have to activate it under the security tab as shown in the screenshot I attached. Custom visuals that you download naturally come with different expectations as only some are certified. I would have thought visuals in the default list would be certified as a precondition to be included on the default list. Is it possible it's certified? It's not on the list. Under Visualizations, when I right-click on the ArcGIS visual icon and select "About" the pop-up states that the source is 'default visual.' I did not add ArcGIS to Power BI. Then you can start to determine what slows it down or causes it to fail. Perhaps try inserting a very simple map without much on it and see if you can export that to PDF. I'm unable to share the entire PDF. I only have about 150 points on my map and not much data behind it. The new "Layers " box does not appear in my visual though even though I have it turned on. I am able to open a dashboard with an ArcGIS visual in Power BI Desktop (government) and from ' to PDF' I do generate a PDF with a map visual.
Only ms certified visuals can be exported to pdf format. Subject: ArcGIS Maps and Publishing to PDFĪrcgis visual is still on process to be certified. But every once in a while it seems to work but I can't figure out why. Or your network speed or the complexity and volume of information being managed through your ArcGIS map.Īs anyone in the group had experience with this in the desktop or online? Many of the maps I generate also have reference layers which I'm sure make the process of rendering the map even slower. Or whether it has something to do with the amount of RAM you have on your computer.
I haven't really been able to test to see if this only a problem on the desktop. If there's only a set amount of time to capture an image then the content on that page will be captured but exclude the ArcGISmap as time runs out before the process can finish, moves onto the next page. Generating an ArcGIS is map in PowerBI takes time, or at least it does on my desktop. My guess is that when the PDF is being generated it goes through each dashboard one of the time and allocates a certain amount of time to render the dashboard and then capture the image and then move on to the next page. This might be different in PowerBI services however officially I only have access to PowerBI desktop and I've noticed that if you try to export a dashboard that contains an ArcGIS map when doing a PDF publication the maps will not be included in the output.