There it is, no Photoshop, this is real. Thank you to Microsoft’s CRM maven and top bloke Mark Rettig for inspiring me to revisit this and for giving me the ‘cross-scripting’ trick. This is how I do it.
Create Your Power View Spreadsheet
If you have Excel 2013, Power View comes as part of the package. Go to Insert-Power View to generate a pretty and powerful representation of your data. In my case, I browsed online and found some data showing industry sales by country.
After a bit of playing with the Power View I got the Map view you see in my dashboard.
Load the Spreadsheet into your SharePoint Site
Initially I tried using OneDrive but I could not get it to show the Power View sheet so SharePoint it is. As my long-term readers will know, I have an Office 365 subscription. Being cheap, this is a P1 plan which costs me US$6 per month and takes care of my email. It also comes with SharePoint which, until today, I had not done a lot with. Going to the SharePoint Team Site document store, I loaded up my spreadsheet.
As you can see, we get control of the permissions if we need to restrict access to the spreadsheet. Ticking it and selecting ‘View in Browser’ shows the Power View in my browser and gives me a URL to use.
Create a New Dynamics CRM Solution
This is where Mark’s trick comes in. If you try and add the URL directly to a dashboard in CRM it does not work; nothing shows up. This is because, cross-scripting is forbidden for dashboard iframes created against the base solution. To get around this, we create a solution and create the dashboard there. Now we can add an iframe to the dashboard and turn off cross-scripting
We are then good to go. We can add whatever else we like to our dashboard and it all just works. Have fun.