A new video is out from Microsoft about the Power BI Admin Center; it’s only 7.5 minutes give it a look!
This the third part in the Indeed! Series and we will cover how to parameterize a query with Power Query from a table in Excel. In Part 2 we setup our Indeed API calls to gather some basic parameterized data with Power Query. It’s nice that we can enter anything; but do we really want to manually enter information each time to change the query? Probably not. The file from Part 2 can be downloaded here. Hopefully you have had a chance to go over to Faisal Mohamood’s blog and read up on parameterizing a Yelp query or for a crazy parameterization in Power Query you can check out Devin Knight’s blog post. Continue reading
This the second part in the Indeed! Series and we will cover how to parameterize a query in Power Query. In part 1 we setup our Indeed API calls to gather some basic data with Power Query. The file from Part 1 can be downloaded here. This probably didn’t help a whole lot of people out unfortunately; unless you are a software engineer in Austin, TX. Hopefully you have had a chance to go over to Faisal Mohamood’s blog and read up on parameterizing a Yelp query or for a crazy parameterization in Power Query you can check out Devin Knight’s blog post. Continue reading
While I am eagerly awaiting the preview for Power BI; I need to have something to test out in this online offering once it’s available. So in my first installment on Power Query, Power Pivot, Power View and Power Map I wanted to create an example that would truly be BI for everyone. Job search and employment opportunities came to mind. I started poking around for accessible API’s only to discover Indeed
offered one that could be hooked into with Power Query; now we are off to the races. In this post I just want to cover the basics of Power Query; importing data, splitting columns and getting data from an API. It’s a good idea to have an overall plan though; what does this running example need to be eventually be? Continue reading
Blog summaries are fairly standard across the web. A paragraph with three periods and people can click the link or title to get to the full blog post is, for the most part, the norm in my experience looking at other people’s blogs. So how do you do it in the Office 365 public site blogging app? The short answer is you don’t without custom JSLink files or some major editing; I’ll be submitting another ticket listing this as a bug and updating this post with the responses. So here is my adventure in blog summary attempts… Continue reading
Awesome update on Power BI with a lot of links!
This is just a quick post to summarise the Power BI-related information that has come to light over the last few weeks; this is all stuff that has been tweeted extensively (follow me!), but I know not everyone spends their life on Twitter so here you go:
- The Power BI mobile app has appeared in the Windows 8 app store. Check out these posts from Jen Underwood, A.J. Mee and Parikshit Savjani for more details:
There’s also a detailed video on YouTube showing a demo of it:
- The maximum size of a workbook you can upload to Power BI will be 250MB, as stated here:
- There’s a new option to use the HTML 5 viewer for Power View reports in the browser:
- The full Power BI online help has been published. Links to all the help docs and more can be found…
View original post 91 more words
After trying to get the blog summary configuration in place in SharePoint and doing some feature discovery; I’ve decided to move on over to WordPress. WordPress seems more in line with Blogging; this first go around on SharePoint 2013 on the public side was disappointing. The internal site I still love with the rich feature set and sub-site spawning I could really see using it as a consultant to track documentation, deliverables and everything under the sun. Continue reading