Navigation

Search

Categories

On this page

PowerBI: Add licenses to existing Office365 accounts
Excel PowerQuery: Plano de Frequencias (Canais Analogicos)

Archive

Blogroll

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.



RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 121
This Year: 0
This Month: 0
This Week: 0
Comments: 35

Sign In
Pick a theme:

# Monday, 21 July 2014
Monday, 21 July 2014 19:11:45 (GMT Daylight Time, UTC+01:00) ( )

Adding licenses is one of those manual processes you won't want to do manually. PowerShell is really nice for these tasks, but sometimes just getting a script to run is also a challenge.

Recently we found conflicts with a duplicate service (SHAREPOINTENTERPRISE) in the base ENTERPRISEPACK and the new POWER_BI_STANDALONE.

Some error messages (for Google): Set-MsolUserLicense : Unable to update license for this user. The set of licenses includes two or more service plans which cannot be assigned at the same time. Conflicting Service Plans: SHAREPOINTENTERPRISE, SHAREPOINTENTERPRISE.

Since I've already spend some minutes on this Set-MSOLUserLicense, here is our script to license everyone in your team:

Connect-MsolService

$tenant
					= (Get-MsolAccountSku)[0].AccountSkuId.Split(":")[0]
								

$newLicense
					=
					"$tenant`:POWER_BI_STANDALONE"
						

$license
					= New-MsolLicenseOptions -AccountSkuId
					$newLicense
					-DisabledPlans
					SHAREPOINTENTERPRISE
				

 

get-msoluser |
				

    ?{-not
					$_.Licenses.AccountSkuId.Contains("$newLicense")} |
							

    Set-MsolUserLicense -AddLicenses
					$newLicense
					-LicenseOptions
					$license
				

 

#check who is licensed
				

get-msoluser | ?{$_.Licenses.AccountSkuId.Contains("$newLicense")} 

 

#check License usage
				

Get-MsolAccountSku 

 

Special thanks to @motadb for helping me dig this

# Monday, 07 July 2014
Monday, 07 July 2014 22:26:51 (GMT Daylight Time, UTC+01:00) ( )

It's not possible to setup a new TV without manually editing all 35 analog channels or manually sorting after auto-tuning. After discovering how difficult it is to find the list in the internet, I decided to just share it somewhere.

PS: My search was not easy as this operator recently changed the brand completely and forgot to publish the information on the new website. Anyway, found some parts in forums online, so here goes my contribution, and how I ended up formatting the table in Excel (and PowerQuery).

So my simple exercise is just parsing this:

Into something more readable like:

 

The easy way is by splitting using position from right to left.

Visual tools are great and in the end the generated code was:

= Table.SplitColumn(Source,"Column1",Splitter.SplitTextByEachDelimiter({" "}, null, true),{"Column1.1", "Column1.2"})

Here is the final table, just for googlers out there:

Plano de Frequências ZON e/ou NOS

Posicao

Canal

Frequencia

1

RTP1

C-5

2

RTP 2

C-7

3

SIC

C-8

4

TVI

C-10

5

SIC NOTÍCIAS

S-6

6

TVI 24

S-7

7

RTPN

S-8

8

SIC MULHER

S-29

9

SIC RADICAL

C-22

10

RTP MEMÓRIA

C-39

11

PORTO CANAL

C-47

12

RTP ÁFRICA

C-26

13

CANAL PANDA

C-25

14

PANDA BIGGS

C-49

15

HOLLYWOOD

S-34

16

MOV

S-30

17

AXN

S-35

18

FOX LIFE

C-31

19

FOX

S-20

20

MTV PORTUGAL

S-33

21

DISCOVERY TRAVEL & LIVING

C-50

22

TV RECORD

C-34

23

DISCOVERY CHANNEL

C-42

24

ODISSEIA

S-9

25

NATIONAL GEOGRAPHIC

C-45

26

HISTÓRIA

C-43

27

BIOGRAPHY CHANNEL

C-28

28

VH1

S-19

29

MEZZO

S-25

30

EURONEWS

S-26

31

CNN

S-32

32

BBC WORLD NEWS

S-16

33

BBC ENTERTAINMENT

S-17

34

SKY NEWS

S-13

35

ARTV

S-31

36

CANAL DE TESTE

S-12

37

CANAL DE TESTE 2

C-11

38

DESTAQUES DE PROGRAMAÇÃO

S11