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 producti...
Need Help
Tips and Tricks
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

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
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

 

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    arimoldi ,

     

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

    • arimoldi's avatar
      arimoldi
      Icon for Resolver II rankResolver 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's avatar
        Idrissshatila
        Icon for Super User rankSuper User
        2 years ago

        arimoldi ,

         

        then someone that has access to data should replace the source, there's no other solution