Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSolved! Go to 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
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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHey,
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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |