Forum Discussion

5 Replies

    • tushu1984's avatar
      tushu1984
      Frequent Visitor

      I was able to publish report using PowerBi Import CLI (power shell)command earlier

      but suddenly this command is giving me below error

      No idea why this is coming now..

      powerbi ] Importing C:\Users\pawadet\Documents\PowerBi_reports\ETL_Card_1_Transaction_Failures.pbix to workspace: ddde32f2-a5f9-4027-b7c8-14c7c26989a3
      [ powerbi ] File uploaded successfully
      [ powerbi ] Import ID: 83a1090f-02e5-4255-953e-58f25eb0b052
      powerbi : C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\lib\cli-import.js:69
      At line:1 char:1
      + powerbi import -c $CollectionName -w $WSguid -k $accesKeyPBI -n $Card ...
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      + CategoryInfo : NotSpecified: (C:\Users\pawade...li-import.js:69:String) [], RemoteException
      + FullyQualifiedErrorId : NativeCommandError

      cli_1.Cli.print('Checking import state: %s', importResult.importState);
      ^

      TypeError: Cannot read property 'importState' of undefined
      at C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\lib\cli-import.js:69:70
      at C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\powerbi-api\lib\autorest\operations\imports.js:416:14
      at retryCallback
      (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
      at retryCallback
      (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
      at handleRedirect (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
      at Request._callback (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
      at Request.self.callback (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\request\request.js:187:22)
      at emitTwo (events.js:106:13)
      at Request.emit (events.js:191:7)
      at Request.<anonymous> (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\request\request.js:1044:10)

    • tushu1984's avatar
      tushu1984
      Frequent Visitor

       I was able to publish power bi report using PowerBi Import power shell CLI command

      But suddenly it has stopped publishing and it give me below error .. please can someone help me how it can be resolved

       

      powerbi ] Importing C:\Users\pawadet\Documents\PowerBi_reports\ETL_Card_1_Transaction_Failures.pbix to workspace: ddde32f2-a5f9-4027-b7c8-14c7c26989a3
      [ powerbi ] File uploaded successfully
      [ powerbi ] Import ID: 83a1090f-02e5-4255-953e-58f25eb0b052
      powerbi : C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\lib\cli-import.js:69
      At line:1 char:1
      + powerbi import -c $CollectionName -w $WSguid -k $accesKeyPBI -n $Card ...
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      + CategoryInfo : NotSpecified: (C:\Users\pawade...li-import.js:69:String) [], RemoteException
      + FullyQualifiedErrorId : NativeCommandError

      cli_1.Cli.print('Checking import state: %s', importResult.importState);
      ^

      TypeError: Cannot read property 'importState' of undefined
      at C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\lib\cli-import.js:69:70
      at C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\powerbi-api\lib\autorest\operations\imports.js:416:14
      at retryCallback
      (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
      at retryCallback
      (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
      at handleRedirect (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
      at Request._callback (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
      at Request.self.callback (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\request\request.js:187:22)
      at emitTwo (events.js:106:13)
      at Request.emit (events.js:191:7)
      at Request.<anonymous> (C:\Users\pawadet\AppData\Roaming\npm\node_modules\powerbi-cli\node_modules\request\request.js:1044:10)

  • Hi Everyone,

    I was searching for some Live online help for Powershell.
    However i didn't find any suitable online live group

    So, i thought to create a Skype Group.
    Here we can help each other to solve any Powershell issue or puzzle.

    Please join me on https://join.skype.com/yY056Inw1A8q

    Let's help each other.

    Regards,
    Param

  • Is there any options for developers who would like to access the PowerBI API (specifically updating datasource) via AWS Linux-Based lambda?