Skip to content

Posts from the ‘Hands On Labs’ Category

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.

Read more

SQL Azure Stored Procedure Automation Using Runbooks and Email

Minimize the impact on SQL Automation workflows when migrating to SQL Azure by automating stored procedures using Runbooks and E-mail.  This step by step tutorial and walkthrough will review a solution to provide scheduling via Azure Runbooks with integrated O365 email alerts.

Read more