Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Recreating shared dataset

Hi there,

 

We had an employee which was responsible for all PBI issues in his department.

He created reports and datasets and shared with others, who created their own reports based on shared datasets that he created.

 

That employee left, and IT immediatly deleted all his folders. So now the original PBIX files with the original data sets are gone.

The shared datasets started experiencing some issues in calculated columns, and his team mates contacted the BI department.
Since all their reports are live connection, using PBI Desktop we can't see the DAX behind those calculated columns.

 

Is there a way to recreate / retrieve the original dataset from shared workspace, so we can investigate the issues and retrieve the code?

 

Thanks!

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous You should be able to into the workspace where the shared dataset lives and download the PBIX file.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Greg_Deckler .

      I can download the PBIX, but it shows the calculated columns as 'built in' columns, as if the calculated columns were added on analysis service. 

       

      We can't edit them or see the code. 

      In Lineage I can see the report connecting live to a dataset, so there's no model behind it. I'm trying to have the ability to edit calculated columns added in dataset, but we just can't access it.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        Anonymous Right, I was saying that you need to go to where that live dataset is published and download THAT PBIX.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  Anonymous ,

    The Analysis Services data source is in Live Connection mode, and Live Connection cannot create calculated columns. This option is grayed out in the PBI desktop. You can go to the AS source data to create a new column.

     

    This is the related document, you can view this content:

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.