As I mentioned earlier in Power BI online book, Power Query is a functional language. Knowing functions is your best helper when you work with a functional language. Fortunately Power Query both in Excel and Power BI can use shared keyword to reveal a document library of all functions. I’ve written about shared keyword almost Read more about Power Query Library of Functions; Shared Keyword[…]
In previous videos you’ve learned that we can demonstrate R visualization in Power BI, In this video you will learn how R visualization is working interactively with other elements in Power BI report. In fact Power BI works with R charts as a regular visualization and highlighting and selecting items in other elements of report Read more about Interactive R Charts in Power BI[…]
I get this question asked in webinars, speakings, and comments on my blog posts that Is it possible to use a local file as a source in Power BI and schedule that to be refreshed? The answer is Yes, of Course. You can host your files locally or on a server on premises, and then Read more about Schedule Refresh Local Files on Power BI Web Site[…]
There are many SaaS (Software as a Service) data sources for Power BI, such as Mailchimp, SalesForce, and etc. However I haven’t found anything for Meetup. Meetup on the other hand is a data source that event organizers such as myself use mostly. In this post I will be using Meetup API to connect from Read more about Meetup Data Source for Power BI[…]
You’ve seen a number of custom visualizations of Power BI that we’ve used in Power BI online book previously. In this post you will learn through a quick video how SandDance custom visualization of Power BI can be used to visualize clustering result set of an Azure Machine Learning model. In this video I’ll start Read more about Azure Machine Learning with Power BI SandDance Visualization[…]
The idea of writing a book on Power BI is not new for me, I’ve been thinking about it for a while, even before the first release of Power BI Designer. However, Power BI is fast-paced technology, Microsoft Product team is doing a great job with monthly, and sometimes even more frequent updates. With this Read more about Online Book: Power BI From Rookie to Rockstar[…]