How to keep Your Microsoft Azure Automation Runbook Modules Up-to-Date
This article will review a major trap you can find yourself in when using PowerShell in your Runbooks as Azure Automation does not keep your referenced modules up to date.
Dec 10
Using Azure Data Lake with Power BI
Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.
How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)
Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table. A working Live Interactive Power BI Sample is attached at the bottom of this post.
SSDT for Visual Studio 2017 – Fixing the Install Error
There is an odd error when trying to install SQL Server Data Tools (SSDT), either as a stand-alone, or adding to an instance of Visual Studio 2017. I had the same setup failure, no matter what configuration I was using. The following steps worked for me, and may for your situation.
How to use Azure Data Factory V2 Sliding Windows for SQL Exports to Azure Data Lake
This article reviews the process of using Azure Data Factory V2 sliding windows triggers to archive fact data from SQL Azure DB. This process will automatically export records to Azure Data Lake into CSV files over a recurring period, providing a historical archive which will be available to various routines such as Azure Machine Learning, U-SQL Data Lake Analytics or other big data style workloads.
How to use Data Driven Settings to Control Power BI Reports
It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.
How to Publish Power BI Reports to a Public Web Site
An often overlooked, yet powerful feature of Power BI allows you to publish a report to a website using an embed code. This puts the report and underlying data out for everyone who has access to that web page. The sample page below shows a sample book I published for a training session. The following how-to will walk you through will the steps leverage this feature on your site.
How to Architect Your Power BI Solution
The best place to start when learning to develop Power BI solutions is to review the logical architecture your Data Visualization projects will have. There are many moving parts and pieces to a Power BI solution, especially when looking at the varied data sources you can use. From on-premises to web-based, from public to confidential, you must make sure you expose your data securely. Having a good clear architecture will help you achieve a not only a good solution but also a secure one. The following article will show you how you can architect your own solution.
How to Use and Refresh Power BI Using OneDrive Data Sources
One of the challenges for users with Power BI is being able to use a data source that you can update and flow those changes to your Power BI dashboards and reports. Using an Excel file in OneDrive for Business allows you to have multiple users update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how you can leverage this feature for your own solution.
Late Night Database Audits and eBay don’t Mix Or How Steve Jobs, Apple Engineers and $60 Reignited My Passion
So, I just unpacked my “new” Apple Macintosh Classic. My line I gave my family today is that “Lates nights, balancing databases and eBay don’t mix”. But as it sits there, I am finding an amazing flood of emotion and inspiration that has been missing of late, let me explain.
