by Reid Havens | May 11, 2017 | PowerPivotPro
Many of you may know of our wonderful business partners over at PowerON. Among the services and software they offer is a powerful tool called Power Update that essentially automates the refresh (AND publishing!) of Excel AND Power BI Desktop… The post Using Power...
by Chris Webb | May 11, 2017 | Chris Webb
Amid all the other announcements at Microsoft Build today came one I’ve been waiting for a long time: we can now build our own custom data connectors for Power BI. Here’s the announcement on the Power BI blog:...
by Matt Allington | May 10, 2017 | Excelerator BI
I am an enthusiastic sponsor of Microsoft BI. I have been fortunate enough to build a new career off the back of the great products Microsoft has developed, specifically Power BI, Power Pivot and Power Query. Having said that, I am definitely disappointed with the...
by Chris Webb | May 9, 2017 | Chris Webb
If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For example, here’s a screenshot from Power BI Desktop in DirectQuery mode...
by Gil Raviv | May 8, 2017 | Data Chant
As a follow up of the Web Scraping post, here, In today’s post, we will use the Add Column by Example feature to extract links from web pages. (Note: You may have already read this part here, but I am sure that many readers have missed it), Stay tuned for Part 3,...