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

[edhans]

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.

[TomMartens · Accepted solution]

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 

[edhans]

Ok. I can see that. I create everything in Power BI Desktop and upload/publish from there, but I can see if I created further stuff in the service how the report would now have additional things in it. 

Thanks for your help. And it explains why I always see the exact same thing - it is because of my workflow.