Tracking LinkedIn and Twitter social media shares in Power BI

How to: Retrieve Twitter & LinkedIn share totals for a list of URLs in Power BI / Power Query / M If you have a Power BI or Power Query report that contains a list of URLs, the following M functions can be used to add the number of times the URL has been shared…


SSISDB Reporting with Power BI

Back in 2012 when the project deployment model came out for SSIS, many questions were asked regarding its advantages vs the old legacy deployment model. I still see quite a few customers today who use the old legacy package deployment model. The upgrade/conversion process from package deployment to project is quite straight-forward, and I encourage…


Leveraging Cloud Artificial Intelligence (AI) to transform eyecare

What if a patient has undergone an eye surgery only to discover a residual refractive error as a side effect later? While the surgery may have corrected the near-sightedness, farsightedness or astigmatism, post-operative tests may show poor uncorrected visual acuity (UCVA) indicating that a refractive error persists. Data recorded during patient examination has the potential…


Adding a Continent Slicer to Power BI Reports

HOW TO: Adding a Continent Slicer to Power BI Reports After building Power BI reports for many customers over the past couple years, one thing is certain – people love maps. Nearly every organization I support operates at a global scale, with offices (or business) spanning the world. I’ve recently starting using this small trick…


Friday Five: Showcasing Work From Five Technical Leaders

The Power BI Pitfalls Series Gil Raviv is a Microsoft MVP, Analytics Group Manager at Avanade, and a blogger at DataChant. As a former Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query in Excel 2016. Gil is a highly skilled software development lead with 17 years of experience in…


Power BI Desktop 2017年4月の更新情報(データ接続とクエリ エディター)

Microsoft Japan Data Platform Tech Sales Team 伊藤 Power BI には Power BI Service と Power BI Desktop があり、Power BI Desktop の今回 (2017年4月) の更新では次の機能が追加・強化されました。前回は「レポート」と「分析」について紹介しましたので、今回はこの中から「データ接続」と「クエリ エディター」の Update を紹介します。


Introduction to Dynamics 365 – Data Export Service

Data extraction and synchronization made easy Have you ever wanted an easy ability to replicate Dynamics 365 (online) CRM data to an Azure database for using Azure analytics tools without the added complexity of managing an ETL tool? Did you ever want to use Power BI based reporting over the entire Dynamics 365 organization data?…


Power BI Desktop 2017年4月の更新情報(レポートと分析)

Microsoft Japan Data Platform Tech Sales Team 伊藤   Power BI には Power BI Service と Power BI Desktop がありますが、Power BI Desktop の今回 (2017年4月) の更新では次の機能が追加・強化されました。 レポート 軸タイトルの変更 「マトリックスのプレビュー」強化:列のソート、列のサイズ変更、右端での折り返し 分析 「クイックメジャー (簡易測定)」と「値の表示方法」 (プレビュー) スペイン語での Q&A のサポート (プレビュー) データ接続 Power BI service 内のデータセットへの接続 (プレビュー) Redshift コネクタ:beta support と Power BI Service への発行 SAP HANA & BW コネクタ:パラメータ入力の強化…


We’re Back With The Friday Five!

Channel 9: Developing Windows 10 UWP APP – A Programmer’s Guide to IoT Bilal Amjad is from Lahore, Pakistan. He’s the at CEO Attrayant Designs Pvt Ltd, a software development company. He’s also a founder of instacare, a healthcare company that’s known for being Pakistan’s first instant health care solution.  Follow him on Twitter @mbilalamjad2.         …