dw1186 commented 2 years ago

I can only get this to work if the .pbix already exists in the target workspace. When I deploy a brand new .pbix from DEV to TEST it throws an error unless the .pbix already exists in the target workspace.

nathangiusti commented 2 years ago

Set source_stage_order to 0

name: Migrate via Pipeline
on:
  push:
    branches:
      - main
jobs:
  Deploy-Asset:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v2
        with:
          fetch-depth: 0
      - name: Get changed files
        id: changed-files
        uses: tj-actions/changed-files@v12
        with:
          separator: ","
          quotepath: false
      - name: Power BI Pipeline Deploy
        uses: nathangiusti/Power-BI-Pipeline-Deploy@v2.4
        with:
          files: ${{ steps.changed-files.outputs.all_modified_files }}
          separator: ","
          tenant_id: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
          config_file: ".github/config/pipeline-deploy-config.yaml"
          source_stage_order: 0
        env:
          CLIENT_ID: ${{ secrets.CLIENT_ID }}
          CLIENT_SECRET: ${{ secrets.CLIENT_SECRET }}

dw1186 commented 2 years ago

Thanks for responding.

Below is my code which already has the source_stage_order set to 0. I must have something else wrong. I’ve included the log with the error highlighted in yellow at the end of this email. Any help would be greatly appreciated. Thanks!

name: CI

only run when files in the root of the main branch are committed and ignore changes in the sub-directories.

on: push: branches:

main jobs: DeployToUAT:
The type of runner that the job will run on

runs-on: ubuntu-latest environment: name: EideBaillyWidgets.DeployUAT

Steps represent a sequence of tasks that will be executed as part of the job

steps:

Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
uses: @.*** with: fetch-depth: 0
name: Get changed files id: changed-files uses: @.*** with: separator: "," quotepath: false
name: Power BI Pipeline Deploy uses: @.*** with: files: ${{ steps.changed-files.outputs.all_modified_files }} separator: "," tenant_id: " xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx " (I removed this) config_file: ".github/workflows/config.yaml" source_stage_order: 0 env: CLIENT_ID: ${{ secrets.CLIENT_ID }} CLIENT_SECRET: ${{ secrets.CLIENT_SECRET }}

Dave Winkels Director of Business Intelligence and Analytics Fargo, ND

T 701.476.8426

Access your documents with Eide Bailly Connecthttps://www.eidebailly.com/client-access

@.http://www.linkedin.com/companies/eide-bailly-llp @.https://twitter.com/EideBaillyLLP @.https://www.youtube.com/user/eidebailly @.https://www.facebook.com/EideBailly @.***https://instagram.com/eidebailly/

From: Nathan Giusti @.> Sent: Thursday, October 6, 2022 5:15 PM To: nathangiusti/Power-BI-Pipeline-Deploy @.> Cc: Dave Winkels @.>; Author @.> Subject: Re: [nathangiusti/Power-BI-Pipeline-Deploy] Question regarding deploying a new .pbix (Issue #5)

External Sender: Please take care when clicking links, opening attachments or responding to unsolicited messages.

Set source_stage_order to 0

name: Migrate via Pipeline

on:

push:

branches:

  - main

jobs:

Deploy-Asset:

runs-on: ubuntu-latest

steps:

  - uses: ***@***.***

    with:

      fetch-depth: 0

  - name: Get changed files

    id: changed-files

    uses: ***@***.***

    with:

      separator: ","

      quotepath: false

  - name: Power BI Pipeline Deploy

    uses: ***@***.******@***.***>

    with:

      files: ${{ steps.changed-files.outputs.all_modified_files }}

      separator: ","

      tenant_id: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"

      config_file: ".github/config/pipeline-deploy-config.yaml"

      source_stage_order: 0

    env:

      CLIENT_ID: ${{ secrets.CLIENT_ID }}

      CLIENT_SECRET: ${{ secrets.CLIENT_SECRET }}

- Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnathangiusti%2FPower-BI-Pipeline-Deploy%2Fissues%2F5%23issuecomment-1270754713&data=05%7C01%7Cdwinkels%40eidebailly.com%7C52dd6651ff2249dc37f608daa7e83c85%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638006913163395818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=jlTmYnxMbjz7y4LdedbDYc%2Bq7c0n9N5iuU%2BjQAiSq9A%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAZUST2WTAMKMQXV2HR6E263WB5FO7ANCNFSM6AAAAAAQ67SGAU&data=05%7C01%7Cdwinkels%40eidebailly.com%7C52dd6651ff2249dc37f608daa7e83c85%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638006913163395818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HrOz0LKhtWC3c4tzfonzD1B8HhQmgCfB57QIvZ3dUco%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>

Confidentiality Note: This email message, including any attachment(s), is for the sole use of the intended recipient(s) and may contain information that is confidential, privileged, or otherwise protected by law. Any unauthorized use, disclosure, or distribution of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately by reply email and destroy the original and all copies of the email, including any attachment(s).

nathangiusti commented 2 years ago

@dw1186 Are you attempting to move PBIX reports with embedded datasets? As in the dataset is held within the PBIX file?

dw1186 commented 2 years ago

Yes

Dave Winkels

Director of Business Intelligence & Analytics

Eide Bailly LLP

3203 32nd Ave S.

Fargo, ND 58103-6242

T 701.476.8426<tel:+17014768426>

C 701.361.0733<tel:+17013610733>

F 701.476.8998<tel:+17014768998>

Access your documents with Eide Bailly Connecthttps://www.eidebailly.com/client-access

What inspires you, inspires us.

eidebailly.comhttps://www.eidebailly.com/

From: Nathan Giusti @.> Sent: Sunday, October 9, 2022 3:36:24 PM To: nathangiusti/Power-BI-Pipeline-Deploy @.> Cc: Dave Winkels @.>; Mention @.> Subject: Re: [nathangiusti/Power-BI-Pipeline-Deploy] Question regarding deploying a new .pbix (Issue #5)

External Sender: Please take care when clicking links, opening attachments or responding to unsolicited messages.

@dw1186https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdw1186&data=05%7C01%7Cdwinkels%40eidebailly.com%7C8546bf9db17c4b56ada708daaa35ef22%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638009445917317370%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7PWHRETrryDxW8FxrI3jhhn2Oc5vBtZ%2FBUZcYRnwnZg%3D&reserved=0 Are you attempting to move PBIX reports with embedded datasets? As in the dataset is held within the PBIX file?

— Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnathangiusti%2FPower-BI-Pipeline-Deploy%2Fissues%2F5%23issuecomment-1272623151&data=05%7C01%7Cdwinkels%40eidebailly.com%7C8546bf9db17c4b56ada708daaa35ef22%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638009445917317370%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GHaILtRheUAXMi2PNDhUaUdEOdkOBp0uRwBCv75eG1g%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAZUST2SSOO757DCZAWOFIULWCMUERANCNFSM6AAAAAAQ67SGAU&data=05%7C01%7Cdwinkels%40eidebailly.com%7C8546bf9db17c4b56ada708daaa35ef22%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638009445917317370%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=WBUUOEQ%2Fvv%2BKjQlmdQR%2FsgcVDdRhSRX%2Fq1Lv0g260lE%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.***>

Confidentiality Note: This email message, including any attachment(s), is for the sole use of the intended recipient(s) and may contain information that is confidential, privileged, or otherwise protected by law. Any unauthorized use, disclosure, or distribution of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately by reply email and destroy the original and all copies of the email, including any attachment(s).

dw1186 commented 2 years ago

Everything works fine when the .pbix already exists in the target workspace. It only errors out when a new report is being deployed to a workspace where it does not already exist.

Dave Winkels Director of Business Intelligence and Analytics Fargo, ND

T 701.476.8426

Access your documents with Eide Bailly Connecthttps://www.eidebailly.com/client-access

@.http://www.linkedin.com/companies/eide-bailly-llp @.https://twitter.com/EideBaillyLLP @.https://www.youtube.com/user/eidebailly @.https://www.facebook.com/EideBailly @.***https://instagram.com/eidebailly/

Confidentiality Note: This email message, including any attachment(s), is for the sole use of the intended recipient(s) and may contain information that is confidential, privileged, or otherwise protected by law. Any unauthorized use, disclosure, or distribution of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately by reply email and destroy the original and all copies of the email, including any attachment(s).

nathangiusti commented 2 years ago

@dw1186

I believe the issue is due to the PBIX files containing the dataset. Our current use case separates datasets from reports. I will need to make some updates to handle this.

dw1186 commented 2 years ago

Thank you for looking into this. For a new Power BI dashboard, what would the appropriate steps be to deploy using your action? Would I have to manually deploy the dataset prior to running your action? Thanks again.

Dave Winkels Director of Business Intelligence and Analytics Fargo, ND

T 701.476.8426

Access your documents with Eide Bailly Connecthttps://www.eidebailly.com/client-access

@.http://www.linkedin.com/companies/eide-bailly-llp @.https://twitter.com/EideBaillyLLP @.https://www.youtube.com/user/eidebailly @.https://www.facebook.com/EideBailly @.***https://instagram.com/eidebailly/

From: Nathan Giusti @.> Sent: Thursday, October 13, 2022 9:40 AM To: nathangiusti/Power-BI-Pipeline-Deploy @.> Cc: Dave Winkels @.>; Mention @.> Subject: Re: [nathangiusti/Power-BI-Pipeline-Deploy] Question regarding deploying a new .pbix (Issue #5)

External Sender: Please take care when clicking links, opening attachments or responding to unsolicited messages.

@dw1186https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdw1186&data=05%7C01%7Cdwinkels%40eidebailly.com%7C08b65d594b324f7e1a9408daad28c4ed%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638012687891467524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5T%2FZNNcP5V2bKtYWximKuwV80hHIfDKtrB3%2BpaBkfVU%3D&reserved=0

I believe the issue is due to the PBIX files containing the dataset. Our current use case separates datasets from reports. I will need to make some updates to handle this.

- Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnathangiusti%2FPower-BI-Pipeline-Deploy%2Fissues%2F5%23issuecomment-1277722084&data=05%7C01%7Cdwinkels%40eidebailly.com%7C08b65d594b324f7e1a9408daad28c4ed%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638012687891467524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vl2Fl9elF%2FtKEV1gX3RTZCYG4NYEnzsZxfihp81QYi0%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAZUST2XFSDLE6MBZZZFXK6DWDANK7ANCNFSM6AAAAAAQ67SGAU&data=05%7C01%7Cdwinkels%40eidebailly.com%7C08b65d594b324f7e1a9408daad28c4ed%7C220568a8fd7d48a1978a0fff06c0bc35%7C0%7C0%7C638012687891467524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2UGJv90MnZ5SNOycAn0tCiv7ivOum8ffPf1Men68uhk%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.**@.>>

Confidentiality Note: This email message, including any attachment(s), is for the sole use of the intended recipient(s) and may contain information that is confidential, privileged, or otherwise protected by law. Any unauthorized use, disclosure, or distribution of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately by reply email and destroy the original and all copies of the email, including any attachment(s).

nathangiusti commented 2 years ago

Yes unfortunately. I will look into supporting this.

nathangiusti commented 2 years ago

See new release v2.5

nathangiusti / Power-BI-Pipeline-Deploy

Question regarding deploying a new .pbix #5

only run when files in the root of the main branch are committed and ignore changes in the sub-directories.

The type of runner that the job will run on

Steps represent a sequence of tasks that will be executed as part of the job

Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it