Steps to connect to Sql server on Windows Azure Virtual Machine from local machine


Here are the detailed steps to connection Sql instance in a Windows Azure Virtual Machine, from your local machine, through SQL Server Management Studio.

Assume you have already had Sql Server installed on the VM, and SSMS installed on your local machine.

1, Configure your virtual machine’s firewall to allow connection to port 1433

a)      Go to windows firewall, launch Advanced Settings;

b)      Select Inbound rules on the left, and click “New Rule…” on the right;

c)       Select Port in New Inbound Rule Wizard, click Next;

d)      Make sure TCP is selected, and put 1433 in Specific local ports text box, click Next;

e)      Select Allow the connection, click Next;

f)       Select Domain, Private and Public, click Next;

g)      Put whatever name in the Name field, click Finish;

2, Create an endpoint for the VM, to forward port 1433 to 1433

a)      To go the new Windows Azure portal

View original post 184 altre parole


Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons

Chris Webb's BI Blog

A very common requirement when building Power BI reports is to allow the end user to change what is displayed on a chart axis dynamically. A lot of people have blogged about how to do this – Kasper’s blog post here is a great example – but the problem is that all of these solutions involve a lot of work remodelling your data and writing DAX code. However, the good news is that now we have Bookmarks and Buttons in Power BI there’s a new, easy, code-free way of achieving the same result, at least for some chart types. In this post I’ll show you how using the same data that Kasper used in his post.

Say you have the following dataset (using data from the Adventure Works DW sample database) in Power BI Desktop:


…and you need to display a column chart that shows the sum of SalesAmount broken…

View original post 329 altre parole