Webinar Materials Ready: Power BI Rises; Wonderful Things You Can Do


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.

I also encourage you to have a read through our Power BI Training program if you are interested to learn inside out of the Power BI, and do the transition from Power BI Rookie to Rock Star.

Session Title

Power BI Rises; Wonderful Things You Can Do

Session Description

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.


RADACAD – Power BI Wonderful Things You Can Do


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.

Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

Leave a Reply