Forum Discussion

edhans's avatar
edhans
Community Champion
8 years ago
Solved

What is the difference between Report and Dataset in Power BI Publisher for Excel?

I've connected with both in Excel and I cannot tell the difference in what is offered as far as data or pivot table fields.

  • Hey,

     

    assume your dataset is a dataset coming from an on-premises SSAS Tabular model and you create a measure in a report publish the report to the service, then you will find a difference between connecting to report and dataset.

     

    Regards

    Tom

4 Replies

  • Hey,

     

    assume your dataset is a dataset coming from an on-premises SSAS Tabular model and you create a measure in a report publish the report to the service, then you will find a difference between connecting to report and dataset.

     

    Regards

    Tom

    • edhans's avatar
      edhans
      Community Champion

      Ahhh... ok. Everything we do here is to the Power BI service (no SSAS Tabular model on prem) so it is the same thing I think.

      • TomMartens's avatar
        TomMartens
        Super User

        Hey,

         

        considering the following:

         

        User 1 publishes a model to the service (no matter, if data connection mode is import or direct query).

         

        User 2 connects to the datasource "Power BI Service" and creates measures, there will also be a difference between Report and Dataset.

         

        Regards

        Tom