Skip to main content
Sign in

Power BI template

Mike Honey

I built a Miradi template for Power BI, that some folks have used to make dashboards presenting their Miradi data, often integrating that with other data.

Power BI is a data integration and visualisation tool produced by Microsoft. It's the market-leading product in that category, with millions of users. There is a Free desktop tool and web license which give you almost all the features, but excludes sharing data securely via their web service.

Here's a link to a preview of that Miradi template, loaded with data from the Miradi sample program.

The page navigation is at the centre-bottom: < 1 of 8 >. Clicking the "1 of 8" text opens a menu of the available pages.

Note this free (unsecured) web publishing method excludes some features available to Power BI licensed users eg export of data.

I'm keen to see this template used more widely and improved, so let me know if you have any questions or suggestions.

3

Comments

15 comments

Date Votes
  • Paul Benfield

    Hi Mike, 

    I'm working on a Power BI dashboard based on your template for a MiradiShare Program that has recently implemented Indicator level classifications. However, in Power BI's navigator I'm not seeing the expected Indicators - Taxonomies table that I would need to include in my model to filter on these classifications. Is there a custom query driving the template that needs to be modified to pull in tables that were not included in the default template?

    Thanks,

    Paul Benfield

    0
  • Mike Honey

    Hi Paul,

    I'm glad to hear you are finding some use for this.

    Yes this would need an extension to the queries and semantic model to create that table and relate it to the Indicators table.  I would start by duplicating an existing Taxonmies query e.g. "Direct Threats - Taxonomies", but repoint the Source to the "Indicators (for KEA)" query.  The resulting table would need a relationship added to the Semantic Model, to connect it on Resource Uri back to the "Indicators (for KEA)" table. 

    Depending on how you are using Miradi, you might need to repeat those steps for the "Indicators (for IR)" data - which is loaded separately.

    BTW, I'm working on an update to the template to switch the maps to the IconMap custom visual (and automate the integration of map data).  I will add those Indicator Taxonomy tables to that update - hopefully all finished by next week.

    Thanks

    Mike

    1
  • Paul Benfield

    Hi Mike, 

    Thanks for the response. I'll look forward to the new version of the template when it becomes available. I'll let you know if this resolves all my issues. 

    Paul

    0
  • Mike Honey

    Hi Paul,

    I have that new version of the template ready.  Here's the link to the github project:
    https://github.com/Mike-Honey/miradi/

    Mike

    0
  • Paul Benfield

    Hi Mike, 

    Thank you! Now that I'm back we'll start testing this. 

    Paul

    0
  • Paul Benfield

    Hi Mike, 

    One initial problem we're encountering is, after switching the data source to our MiradiShare program and then applying the change in Power BI this fails while evaluating the Project Footprints table, error is: 

    Project Footprints - WKT
    ADO.NET: A problem occurred while processing your Python script. Here are the technical details: The file is too long. This operation is currently limited to supporting files less than 2 gigabytes in size.
    Query parameters

    Are there any options I would need to tweak in Power BI to deal with this? 

    Paul

    0
  • Mike Honey

    Hi Paul,

    It sounds like you might have a really large spatial shape for one (or more) of your project boundaries/footprints - possibly an imported shape.
    I don't think I will be able to resolve this from the Power BI / python end.  I do have steps in the python script to simplify large shapes and break them into chunks, but it sounds like that error is being thrown when the script first tries to acquire the shape data.
    Shape(s) that large might be causing other performance issues in Miradi itself - could you create a Miradi Support Request and ask them to look into this?

    Mike

    1
  • Charles Latremouille

    Hi Mike and Paul,

    Hope you are well. I am having issues with my Power BI connection with Miradi and I would like to know if you are having similar issues. I refreshed my Dashboard in Power BI and it seems like all my tables are now empty. Not sure if the issue is on my end or with Miradi. I did not do any major changes to my Power BI file in the recent months and it was always working fine up until now.

    Everything working for you?

    0
  • Miradi Support

    Hi Charles,

    I'm sorry you are having this trouble!

    We haven't made any changes on the Miradi API side so it is most likely a Power BI issue. Have you tried deleting / recreating the Data Source in Power BI as well as clearing the Cache / Data Cache, and then refreshing?

    Keep us posted on how it's going.

    Kari

    0
  • Charles Latremouille

    Hi Kari,

    I redownloaded the Power BI connector, cleared the permissions for Miradi Share, cleared cache, refreshed, all the connections seem to occur correctly but again all my tables show up empty. I tried with a blank report and the same thing happens. Any idea what else I could try?

    Thanks,

    0
  • Miradi Support

    Thanks for the additional information, Charles. I'll touch base with our tech support folks and get back to you shortly.

    0
  • Mike Honey

    Hi Charles,

    I was just able to refresh my copy of the template, which is pointed at the Miradi Islands Seascape (Example Program).

    So it sounds like the issue might be something to do with your account or your program?

    Mike

    0
  • Charles Latremouille

    Hi Mike,

    Thanks for looking into this. Kari and Andy will be investigating.

    Cheers,

    0
  • Charles Latremouille

    Problem resolved, seems like I momentarily lost manager priviledges in my program.

    Thank you Kari!

    0
  • Mike Honey
    • Edited

    Hi all, I just released a "2025-05" update to this template.  I've extended the use of python scripts to take over the HTML stripping from the embedded Power BI M functions.  This resolves some bugs and requires far fewer lines of code.

    I also improved the performance of several measures, and there are new measures for % Complete and Progress Status.


    More details and the updated PBIX file are available on the GitHub project:

    https://github.com/Mike-Honey/miradi

    Let me know if you have any questions.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post