Forum Discussion

arimoldi's avatar
arimoldi
Icon for Resolver II rankResolver II
2 years ago

How to manage report deploy based on data sources with sensible data

Hi,

 

I have developed a dashboard on Power BI based on an fake / anonymized excel file stored in a Sharepoint folder; now the dashboard is ready and I have to deploy this dashboard in the production workspace.

The point is that I have developed this dahsboard using a fake / anonymized excel file and once the dahsboard will be in the production workspace it should be connected to the real file with sensible data that I cannot see / read and on which I should not have access.

 

How can I manage the deploy of this dashboard and the connection to the new source without reading or having access to the real file with sensible data?

 

Thanks,

Andrea

 

7 Replies

  • Hello arimoldi ,

     

    they should have the same table names and column names as in the production, it's case sensitive as well.

    • arimoldi's avatar
      arimoldi
      Icon for Resolver II rankResolver II

      Hi,

       

      yes they have the same column names, structure and data type.

       

      Reading your answer I think I didn't explain well the problem: how can I deploy a report in the production environment without having the access on the data source?

       

      Thanks,

      Andrea

       

  • Hi arimoldi ,

     

    Agree with Idrissshatila . You should get somebody with access to the datasource to publish the Power BI report. 

    It would also help in the future if any updates and maintenance needs to be carried out - since you don't have access to the Data Source, you won't be able to make any changes in the Power Query.