Wednesday, March 7, 2018

PowerBI: Logging into multiple Microsoft PowerBI.com accounts for different companies at the same time

I have a great tip today!

 As a consultant, I find it difficult to switch between accounts on PowerBI.com.

 I have to log out of an existing account and log back in to a new account. The login process takes a long time. I have found a work around. I use google chrome to manage different chrome accounts, different themes, different cookies, and this allows me to stay logged in to multiple power bi accounts at the same time.

 1. In Chrome, click the title bar on the upper-right corner of the screen.

 You'll see your name, probably:

 

 2. Click on your name and pull down the menu. Click Manage People.

 3. Add different names for each of the Power BI accounts that you manage. I start mine with "Client - " and the name of the company, just so they're all grouped together.

 Now, each time you click on a profile, you will open a new chrome window. That profile will have different cookies, settings, bookmarks, and themes. I use themes to tell them all apart from each other. I use bookmarks to keep VPN logins, JIRA boards, TFS, and Azure logins all separate from one another.

 Here, I made a video on this for you:

 Hope this helps you!

 Ike

Tuesday, February 21, 2017

Visual Studio Azure Data Lake Issues

I had a weird issue with Visual Studio and Azure Data Lake.  It manifested itself in three ways:

1)  In the server dropdown of the U-SQL script editor, I could only see (Local) and not my ADLA account:


2)  When I closed an ADLA solution and reopened it, I would get "project not available."


3)  In Azure Cloud Explorer, I would get "Resource Unavailable" underneath Data Lake Analytics:


I couldn't figure out what the problem was.  I had a lot of tools installed and I think some were in beta...or I had an old version of the Azure Developer Tools.  I tried removing everything and readding it, but the problem persisted.

I finally just shotgunned the problem and created a new VM image.  I installed the following things in this order:

1)  Visual Studio 2015 Professional with Update 3.
2) Azure Developer Tools from this link: https://azure.microsoft.com/en-us/tools/
3) Azure Data Lake Tools (the Feb 8th build) from this link:  https://www.microsoft.com/en-us/download/details.aspx?id=49504

My problems all went away.  Hope this helps someone else.