Forum Discussion

Kwarren35's avatar
Kwarren35
Frequent Visitor
5 years ago

Deployment Pipelines - Dataset is different after a "Successful" Promotion from DEV to TEST

Hello,    We have been using Deployment Pipelines fairly successfully for 2 months now and working through issues. We need some ideas on how to best troubleshoot what is causing the dataset to be d...
Need Help
Kwarren35's avatar
Kwarren35
Frequent Visitor
5 years ago

Nimrod_Shalit

1. The BI developer applied the Role Level Security rules to the dataset before publishing to DEV workspace.

2. The deployment pipelines interface shows the "sales" dataset as non-equivalent between DEV and TEST, but I cannot spot a differences when comparing files

eligr's avatar
eligr
Icon for Power BI Team rankPower BI Team
5 years ago

Hi Kwarren35 !

Sorry to hear about that.

We have a bug in that area, working on fix right now.

 

Eli.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello. I think I have the same error here. There is already a fix ? 
    If in dev I make an update that changes my dataset, when deployed to test it will keep saying that there is differences between the two datasets. Then, if I download the dataset .pbix from the test workspace, i can see that is is all messed up (tables names and fields) . I can only get this ok if I delete everything from test and deploy again from the beginning what is not good. 

    There is any solution ? 

    • Nimrod_Shalit's avatar
      Nimrod_Shalit
      Icon for Power BI Team rankPower BI Team
      5 years ago

      Anonymous , few questions:

      • Is it happening on other items in your pipeline, or just datasets?
      • Is it happening on other datasets, or just this particular one?
      • Did it happen several times on that dataset, or just once?
      • What change did you made, that caused it to happen? or any change ends up with same result.

      Also note that downloading a PBIX that been created/ updated through deployment isn't supported, so you might get corrupted files. We will block the option to download in the near future.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello , 
        For now I am just working with a single dataset that feed a report. So, it is just happening to  the dataset, what has then an effect in the report. 
        It was more than one time and to fix it I had to delete the content of the workspace and deploy again. 
        The changes that I made that lead to this were changes in the model in PowerQuery. One time was the adding of a new table and the other time was the change on a step in a query. 
        How I manage the process : I made the changes in the PowerBi desktop and then I publish to the dev workspace, overwriting the existing content. Automatically the comparison in the deployment pipeline detects that there are differences in both objects : report and dataset. I select both and deploy to test environment. Then no differences are detected between the report, but the dataset still detects differences. When I said that I download the .pbix is not from the deployment is from the test workspace view. 

        I am not saying that it happens everytime I did changes in the model, but at least in these times it happen. 

        Thanks a lot.