Forum Discussion
Community ChampionWhat 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
- TomMartens
Super User
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
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
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
