Forum Discussion

edhans's avatar
edhans
Icon for Community Champion rankCommunity 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.
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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
Icon for Community Champion rankCommunity Champion
8 years ago

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
Icon for Super User rankSuper User
8 years ago

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's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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.