Forum Discussion
how to app.powerbi.com
rabers Basically power bi desktop is the designer tool and power bi service is web app to access reports and dashboards. You can also connect straight to some data sources from power bi service and build reports and dashboard there but you don't get advanced data manipulation capabilities that you get in desktop app. General process if you use power bi desktop to connect to data source -> perform your data manipulation there -> build report -> publish to power bi service -> build dashboard from published report in power bi service -> share that dashboard with others.
So to answer your question you can use power bi desktop to connec to all your tables and publish that to cloud or use power bi service to connect straight to tables in your data source provided power bi service allows support for that type of data source (example azure sql database).
Community Championrabers Basically power bi desktop is the designer tool and power bi service is web app to access reports and dashboards. You can also connect straight to some data sources from power bi service and build reports and dashboard there but you don't get advanced data manipulation capabilities that you get in desktop app. General process if you use power bi desktop to connect to data source -> perform your data manipulation there -> build report -> publish to power bi service -> build dashboard from published report in power bi service -> share that dashboard with others.
So to answer your question you can use power bi desktop to connec to all your tables and publish that to cloud or use power bi service to connect straight to tables in your data source provided power bi service allows support for that type of data source (example azure sql database).
hi Ankit,
ok. I got that I need to design first at the desktop app. but my further question is:
assuming I'm building a dashboard which requires orders, order details, product, product categories, sales persons, inventory, customers, etc. (classic old-school sales dashboard)
in order to do that in other BI tool, I'd build some kind of star scheme ERD and based on that- I'd create my dashboard.
is it possible with Power BI Desktop? according to your comment:
"connect to data source -> perform your data manipulation there -> build report -> publish to power bi service -> build dashboard from published report..."
(haven't tried yet) is seems not...
am I wrong?
