Thanks to all attendees to my webinar yesterday. It was pleasure to have you all attending in this session. I’ve uploaded session slides here and you can download them. Session was mostly demos rather than slides however. Unfortunately there was a technical issue and session didn’t recorded. I will get this recorded offline and upload it later on in RADACAD youtube channel, so subscribe to our channel and stay tuned. I also responded some of questions I’ve got in this webinar at the end of this post.
Power BI Rises; Wonderful Things You Can Do
Power BI comes with bunch of new tools and features; Power BI Desktop is great editor for Power BI solution, it integrates Power Query for data transformation, Power Pivot for modeling, and Power View for data visualization. Power BI also has Android, Apple and Windows apps. Power BI website also provides some level of slicing and dicing the data, as well as dashboards features.
In this session you will learn through many live demos how to get most of Power BI for real world scenarios. You will be amazed with features of Power BI and what you can do with this toolset.
You will learn how easy is to build a Power BI report and dashboard on top of a transactional database. You will be also familiar with Custom Visuals, and how to use them in your solution. Right after this session you can start building your Power BI solution.
Questions and Answers
Q: But when you click on import the data will load to where?
A: Import will load the data into the memory (Power Pivot is an In-Memory xVelocity engine for data model) and also into the Power BI solution itself (Power BI solution is your Power BI file that stored on the disk). anytime you open the Power BI solution and refresh the data it will be loaded into the memory again.
Q: It looks like the cross-filter direction of the relationship was originally single instead of both, which caused the problem. After deleting & re-adding, it was set to both. (PS: Very nice handling of a hiccup – I’m impressed!)
A: Yes! There was an issue in the automatic relationship configuration between two tables at the demo, which by changing it fixed. Thanks for your feedback 🙂
Q: how about organisation who can’t load there data into the cloud. for example; clientdata. Is there a possibility to run Power BI website on-premises?
A: Power BI doesn’t always load your data into cloud. There are two options (in most of the cases) for connecting to the data source: Import, and DirectQuery. (Not all data sources have these two options however). DirectQuery connection is a live connection to the data source. Your data won’t be loaded in the cloud with this type of connection. You can keep your data on-premises and connect to it through live connection with gateways that create the connection channel from Power BI website to on-premises data sources.
Q: does every desktop user therefore have their own definition of the relationships, or can that be centrally defined?
A: For a real world solution your Power BI report will be shared as a centeralized solution to multiple users, and they all use the same report, same model, and of course same relationship definition. However if a user has his/her own copy of the solution he/she can modify the relationship as he/she wants.