Building a dashboard on top of a web API with Power BI and Azure – Part 3

In Part 1 of this series we connected to the driveBC API in Power BI Desktop and built a simple dashboard. In Part 2 we designed the architecture capable of storing the data over time. In Part 3 we are implementing implement the architecture. In the previous article, we defined our architecture as follow: We…


Creating an OAuth 2.0 authentication token for Azure Data Lake Store

Hi All!   A Data Lake can be defined as a storage repository that holds a vast amount of raw data in its native format until it is needed. My question is, what would be the point of storing all this data if you can’t access it easily? Azure Data Lake store, which is Microsoft’s…

0

Microsoft Data Platform events in Canada: SQL Server, Power BI, Cortana Analytics and IoT

Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT solutions? Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions. Please find the upcoming events list below. This page will be updated…


Microsoft Data Platform events in Canada: SQL Server, Power BI, Advanced Analytics and IoT

Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT solutions? Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions. Please find the upcoming events list below. This page will be updated…

0

MVP Series: 7 Ways to Lose Your DBA Job

We are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week.  We hope you enjoy them, please feel free to leave a comment. Thanks to Karen Lopez for…

14

Canadian County and Postal Code Shading in Power Map for Excel

Good news for Canadian users of Power Map. I discovered by playing with a dataset that it’s now possible to shade polygons in maps at both county and postal code levels! To my knowledge his was not previously possible as only Country and Province shading was available. I was surprised it worked when I mistakenly…

7

MVP Series: Top 5 Interview Questions for a SQL Server DBA

For the next couple months we are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts around their favourite tips, tricks & features of SQL 2014.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week.  We hope you enjoy…

1

Microsoft Data Platform events in Canada: SQL 2014, Power BI, Predictive Analytics and BIG Data

Want to get familiar with the new SQL Server 2014, Power BI, Azure Predictive Analytics or Microsoft Big Data solutions? Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions. Please find the upcoming events list below. This page will…