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