Forum Discussion

Icon for Resolver II rank

Resolver 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 producti...

Tips and Tricks

Icon for Resolver II rank

Resolver II

2 years ago

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

Icon for Super User rank

Super User

2 years ago

you need to reference the new datasource in the power query source.

arimoldi
Resolver II
2 years ago
that's correct, but it is not enough, because I have no access to the new datasource since it contains sensible data that I cannot access/read, while the dashboard was developed on test/fake data.

This is the error that I get when I connect the new datasource to the dashboard in Power BI Desktop:

Any other suggestions?

Thanks,
Andrea
- Idrissshatila
  Super User
  2 years ago
  arimoldi ,
  
  then someone that has access to data should replace the source, there's no other solution
  - arimoldi
    Resolver II
    2 years ago
    unfortunately this is not possibile and not compliant with our Company structure, because people that have access to those file are from business, they have no technical skill and they don't have Power BI installed.
    
    I can't believe that in the Power BI architecture there is no way to develop a report on file with fake / test / anonymized data and then switch the connection to the real file in the production workspace.
    
    Any other suggestions?
    
    Thanks,
    Andrea