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 always do training based on the assumption that you should create your reports in Desktop, publish them to service, created dashboards and then publish an app
However, you can connect to your data in Service and even create reports in service
So with that in mind, people have been asking me, what is the point to doing it in desktop when you can do it all in Service.
How do I answer that question?
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
hi @DebbieE - Just adding a visual and dots that differentiate Power BI Desktop and Service
Some of the unique features of Power BI Desktop include:
Some of the unique features of Power BI Service include:
Proud to be a Super User!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
thats fantastic,
I can definitely explain the DAX angle. I thought that Power Query was available in Service now because of the dataflows though?
But I can totally go with 'If you want to do DAX, or anything in Data, Model then you MUST use desktop'
I still say always go with Desktop. I find the ability to edit reports in Service so confusing because if someone amends the desktop versions its going to overwrite anything that happens in Service anyway
@DebbieE Yeah, it's easy to get two different versions of the report if you're not careful, and since desktop gives you DAX and Data Model, you often end up needing to go back there anyway so it is probably still best to just recommend using Desktop for editing reports.
I forgot about themes, so love the visual @Sumanth_23 has posted too. 🙂
UPDATE: Oh, and regarding Power Query in Service - that does only work with dataflows as far as I know right? So if the report doesn't use dataflows then you still need desktop.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
hi @DebbieE - Just adding a visual and dots that differentiate Power BI Desktop and Service
Some of the unique features of Power BI Desktop include:
Some of the unique features of Power BI Service include:
Proud to be a Super User!
perfect visual to get that question answered.
Thank you
This topic might be worthy of a community blog post. Just a thought...
Proud to be a Super User!
Paul on Linkedin.
Really good idea. I might have a look at that
Covering 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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |