Offline installation of PowerBI PowerShell Module

[prakash82x]

Hi, I have been trying to perform PowerShell module instalation of MicrosoftPowerBIMgmt on a server which does not have Internet Connectivity and have not been successfull so far.

I would appreciate any help on this.

Here is what I have tried so far.

* Saved the module on a server which has Internet Connectivity

Save-Module MicrosoftPowerBIMgmt -Path C:\temp\PowerBIPSModule

Zipped the folder and copied it over to the destination server under following location:

C:\Program Files\WindowsPowerShell\Modules

It contains several folders as below:

    Directory: C:\Program Files\WindowsPowerShell\Modules
Mode                LastWriteTime         Length Name
----                -------------         ------ ----
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Admin
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Capacities
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Data
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Profile
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Reports
d-----        7/21/2020  10:54 AM                MicrosoftPowerBIMgmt.Workspaces

I am able to list the module and cmdlets also :

PS C:\> Get-Module -ListAvailable
    Directory: C:\Program Files\WindowsPowerShell\Modules
ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Manifest   1.0.840    MicrosoftPowerBIMgmt
Binary     1.0.840    MicrosoftPowerBIMgmt.Admin          {Add-PowerBIEncryptionKey, Get-PowerBIEncryptionKey, Get-P...
Binary     1.0.840    MicrosoftPowerBIMgmt.Capacities     Get-PowerBICapacity
Binary     1.0.840    MicrosoftPowerBIMgmt.Data           {Add-PowerBIDataset, Set-PowerBITable, New-PowerBIDataset,...
Binary     1.0.840    MicrosoftPowerBIMgmt.Profile        {Connect-PowerBIServiceAccount, Disconnect-PowerBIServiceA...
Binary     1.0.840    MicrosoftPowerBIMgmt.Reports        {Get-PowerBIReport, New-PowerBIReport, Export-PowerBIRepor...
Binary     1.0.840    MicrosoftPowerBIMgmt.Workspaces     {Get-PowerBIWorkspace, Get-PowerBIWorkspaceMigrationStatus...

Now when I try to login it errors out:

PS C:\> Connect-PowerBIServiceAccount
Connect-PowerBIServiceAccount : One or more errors occurred.
At line:1 char:1
+ Connect-PowerBIServiceAccount
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], AggregateException
    + FullyQualifiedErrorId : System.AggregateException

PS C:\>

Please help...

[GilbertQ]

Hi there

In order to log into the Power BI Service, it does require Internet connectivity from where the PowerShell module is being run from.

As you indicated the server does NOT have internet, and that could explain why you are getting the error.

What happens if you try the same command on your server that DOES have internet, does it work:?

[prakash82x]

Hey Thanks for looking into this,

Initially I also thought that this is happeing because of no Internet connectivity but that does not seem to be the only reason here.

Here is what I did to prove that.

I installed the Module on a Server with Internet Connectivity using Install-module from PowerShell Gallery and then ran the command Connect-PowerBIServiceAccount. As expected, this command worked fine and without giving any error it opened up an authentication window prompting for Username and Passoword which shows it is working properly.

I then Uninstalled the module from this server and copied the saved modules to module directory that I downloaded using Save-Module command which was copied to the server with no internet.

I again tried the same command Connect-PowerBIServiceAccount, now Ideally this should have worked because the server does have Internet Connectivity but it gave the same error message which we were getting on the server with no internet.

This makes me think that the method I followed to install PowerBI Modules on a server with no internet has something still missing and because of that it is not working on a server with Internet too.

[GilbertQ]

Could it be that it installed some other PowerShell Modules?

Or do you have the latest version of PowerShell installed on both servers?

[prakash82x]

The PowerBI PowerShell modules are the same on both of the servers while PowerShell version is higher on the server with no internet.

PowerShell Version on Server without Internet

PS C:\Windows\system32> $PSVersionTable
Name                           Value
----                           -----
PSVersion                      5.1.14393.3471
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.14393.3471
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

List of PowerBI modules on server without Internet:

PS C:\Windows\system32> Get-Module -ListAvailable
    Directory: C:\Program Files\WindowsPowerShell\Modules
ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Script     1.0.1      Microsoft.PowerShell.Operation.V... {Get-OperationValidation, Invoke-OperationValidation}
Manifest   1.0.840    MicrosoftPowerBIMgmt
Binary     1.0.840    MicrosoftPowerBIMgmt.Admin          {Add-PowerBIEncryptionKey, Get-PowerBIEncryptionKey, Get-PowerBIWorkspaceEncryp...
Binary     1.0.840    MicrosoftPowerBIMgmt.Capacities     Get-PowerBICapacity
Binary     1.0.840    MicrosoftPowerBIMgmt.Data           {Add-PowerBIDataset, Set-PowerBITable, New-PowerBIDataset, New-PowerBITable...}
Binary     1.0.840    MicrosoftPowerBIMgmt.Profile        {Connect-PowerBIServiceAccount, Disconnect-PowerBIServiceAccount, Invoke-PowerB...
Binary     1.0.840    MicrosoftPowerBIMgmt.Reports        {Get-PowerBIReport, New-PowerBIReport, Export-PowerBIReport, Get-PowerBIDashboa...
Binary     1.0.840    MicrosoftPowerBIMgmt.Workspaces     {Get-PowerBIWorkspace, Get-PowerBIWorkspaceMigrationStatus, Add-PowerBIWorkspac...

PowerShell Version on Server with Internet:

PS C:\> $PSVersionTable
Name                           Value
----                           -----
PSVersion                      5.0.10586.117
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.10586.117
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

List of PowerBI Modules on server with Internet:

PS C:\> Get-Module -ListAvailable
    Directory: C:\Program Files\WindowsPowerShell\Modules
ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Manifest   1.0.840    MicrosoftPowerBIMgmt
Binary     1.0.840    MicrosoftPowerBIMgmt.Admin          {Add-PowerBIEncryptionKey, Get-PowerBIEncryptionKey, Get-P...
Binary     1.0.840    MicrosoftPowerBIMgmt.Capacities     Get-PowerBICapacity
Binary     1.0.840    MicrosoftPowerBIMgmt.Data           {Add-PowerBIDataset, Set-PowerBITable, New-PowerBIDataset,...
Binary     1.0.840    MicrosoftPowerBIMgmt.Profile        {Connect-PowerBIServiceAccount, Disconnect-PowerBIServiceA...
Binary     1.0.840    MicrosoftPowerBIMgmt.Reports        {Get-PowerBIReport, New-PowerBIReport, Export-PowerBIRepor...
Binary     1.0.840    MicrosoftPowerBIMgmt.Workspaces     {Get-PowerBIWorkspace, Get-PowerBIWorkspaceMigrationStatus...
Binary     1.0.0.1    PackageManagement                   {Find-Package, Get-Package, Get-PackageProvider, Get-Packa...
Script     2.0.2      PolicyFileEditor                    {Set-PolicyFileEntry, Remove-PolicyFileEntry, Get-PolicyFi...
Script     1.0.0.1    PowerShellGet                       {Install-Module, Find-Module, Save-Module, Update-Module...}

[GilbertQ]

I honestly am not sure why this is not working. I would expect it to

I would suggest logging a support ticket to see how they can resolve this for you?