Forum Discussion

Dhruvin's avatar
Dhruvin
Helper III
8 years ago
Solved

Unable to Connect with Power BI Service using PowerShell

I have installed PowerShell for Power BI using following Code. 

 

Install-Module -Name MicrosoftPowerBIMgmt

 

It is installed successfully.

Now, I used following code-snippet to connect with Power BI Service.

 

Login-PowerBI

When I executed the code it shows me an error like:

Login-PowerBI : The 'Login-PowerBI' command was found in the module 'MicrosoftPowerBIMgmt.Profile', but the module 
could not be loaded. For more information, run 'Import-Module MicrosoftPowerBIMgmt.Profile'.
At line:1 char:1
+ Login-PowerBI
+ ~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (Login-PowerBI:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CouldNotAutoloadMatchingModule

Please refer the screenshot.

 

 

I have also tried to import  module MicrosoftPowerBIMgmt.Profile using following code:

Import-Module MicrosoftPowerBIMgmt.Profile

It shows me following error:

Import-Module : Could not load file or assembly 'netstandard, Version=2.0.0.0, Culture=neutral, 
PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. Reference assemblies should not be loaded for 
execution.  They can only be loaded in the Reflection-only loader context. (Exception from HRESULT: 0x80131058)
At line:1 char:1
+ Import-Module MicrosoftPowerBIMgmt.Profile
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Import-Module], BadImageFormatException
    + FullyQualifiedErrorId : System.BadImageFormatException,Microsoft.PowerShell.Commands.ImportModuleCommand

Below is a screenshot for the same.

 

Please suggest an appropriate solution for it

Need Help
  • JaneLHunt's avatar
    JaneLHunt
    8 years ago

    Hello

     

    I was unable to connect with the Power BI Service with .Net Framework 4.7.02053 installed on my PC.  However, when .Net Framework 4.7.2 was installed from here, I found that I was then able to connect to the Power BI Service using Powershell and run the other PowerShell Management Cmdlets which call the Rest API. 

8 Replies

  • lordtopcat's avatar
    lordtopcat
    Helper I
    8 years ago

    I am getting exactly the same errors. I would very much appreciate some help too.

      • JaneLHunt's avatar
        JaneLHunt
        Advocate II
        8 years ago

        Hello

         

        I was unable to connect with the Power BI Service with .Net Framework 4.7.02053 installed on my PC.  However, when .Net Framework 4.7.2 was installed from here, I found that I was then able to connect to the Power BI Service using Powershell and run the other PowerShell Management Cmdlets which call the Rest API. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I installed 4.7.2 from the link provided in this post and still it is giving me the same error of

     

    "The term 'Login-PowerBI' is not recognized as the name of a cmdlet, function, script
    file, or operable program. Check the spelling of the name, or if a path was included, verify that the
    path is correct and try again."

     

    After checking a bit futher I got .NET version 4.7.03062 (I am working in Windows 7).

     

    Am I missing something as I have downloaded and installed .NET framework 4.7.2 from this link. 

     

    Can this be a path issue. Please help me with this.