According to this post on the official Power BI blog it is now possible to bring your Excel file into a Power BI dataset as a whole (not only importing data); and use portions of it as tiles on your dashboard. Wow: you can (re)use your carefully crafted charts and amazingly engineered pivot tables in a web-shareableRead More
One of the things I like the most about Power BI is the ability to use custom visuals. I did not try building one myself and honestly I think it’s beyond my skills, yet there is a gallery with a growing number of pre-build viz that you can download and use. Go to https://app.powerbi.com/visuals?WT.mc_id=Blog_Visuals andRead More
The Lahman database is one of the most (if not the most) complete free sports dataset
Edit: The base URL has changed from https://api.powerbi.com/beta/myorg to https://api.powerbi.com/v1.0/myorg. OAuth is clearly becoming the de-facto standard for authenticating API calls around the web. In the business intelligence arena, while we can discuss its pros and cons, we undoubtedly must get acquainted with it because sooner or later we’ll be tasked with importing data fromRead More
Second issue of the series about OAuth (you can see the previous here). I’ll try to explain how to use the Google OAuth 2.0 mechanism to authorize a server side scripts without the need of the user’s credentials, in order to automate the INSERT or SELECT (or WHATEVER) processes. I am testing this with BigQueryRead More
I love web services, I love API, I can’t say the same for OAuth! It’s frustrating at times, when you’re not using any of the existing libraries to get the entire flow running. If you have a headless server, with a terminal console and limited programming languages at hand, one of the best options youRead More
