Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

pbix vs pbit

I am new to PowerBI, it says that my PBIT file doesn't have data, where as I am able to see data and apply transformations and all on it. so, what exactly is the difference? please help.

  • Hi Anonymous ,

     

    PBIT file is much smaller than the PBIX file. The reason for this is it keeps all the reporting structure along with the data model schema for your data. This allows you to do all the transformations and reporting changes in this file.

    The only benefit of having a PBIT file is from data security point in the scenarios where you don't want to share the data.

     

    Refer follwing link for more details:

    https://www.youtube.com/watch?v=lZXhtyszO-8

     

    Thanks,

    Pragati

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      Microsoft says that templates do not contain any data, where as i am able to see and also apply transformations on the data. how is it possible?

  • Hi Anonymous ,

     

    PBIT file is much smaller than the PBIX file. The reason for this is it keeps all the reporting structure along with the data model schema for your data. This allows you to do all the transformations and reporting changes in this file.

    The only benefit of having a PBIT file is from data security point in the scenarios where you don't want to share the data.

     

    Refer follwing link for more details:

    https://www.youtube.com/watch?v=lZXhtyszO-8

     

    Thanks,

    Pragati

  • Initially, I was also in the same confusion. But yes in Pbit extestion there is no data. when we open the pbit file we can see that initially there is no data after doing a refresh data came from the source to your pbit file, and now your file is the same as Pbix and you can save it as Pbix.

    In this way we if we share pbit file with some one if he do not have access to db he can not able to refresh data and see data in file.(Data Security)

    Thanks
    Mahesh.