i'm trying to share an excel workbook exported from power bi (from analize in excel tab) with other co-workers, but i can't get it done, is there any way to do it? am i missing something? (i'm using the 60 days pro trial)
Good morning, friends. I'm loving the new #PowerBI desktop. Anyone else addicted to building #dashboard reports in Power BI? #businessintelligence FTW!
I am using latest version of power BI and enjoying preparing different reports, analysis and Dashboards as well. All these documents are very easy to make on Power BI.
Hello Dustin, Thanks a lot, this is very good video for beginners. I am experienced guy into MSBI development. Now I want to learn POWER BI, this is my first video to start.
Great presentation. Been doing DW/DM/BI For over a decade and found your tutorial very useful. I think after this tutorial, I can work on my own without any additional help.
@Dustin Ryan, thanks a lot for your insightful video. you just made clear to me the relationship between Power BI desktop and Power Pivot. I learnt a lot and also connected the missing dots by watching your video
Walk through an introduction to the #PowerBI Desktop with Dustin Ryan. In this video you'll learn to import data, apply transformations and formatting to the data, build a dashboard report with multiple chart types, format the reports, and then publish the report to your Power BI site. #businessintelligence #msbi
Dustin, I really liked your video. I've worked as a Microsoft Trainer for a few years and also consulting with SQL Server. You were very easy to follow and understand. I have also worked with QlikSense and QlikView. It seems that his product does a lot of the same type of stuff. I wanted to be able to talk about the product if someone asks me and with your video, I can more than do that. Thanks for putting it up :)
Hi Dustin. Must confess one the better Intro vids for Power BI I've come across! Like your sample data and how you used it to it's full capacity. Worthwhile signing up to Opusdata to get that sample file. Thanks, keep up the good work!
Thanks, Leon. I'm glad you enjoyed it. I've been toying with the idea of redoing the video with a more publically available dataset that I made available for download. I don't normally like to redo what I've already done, but I would if it was beneficial to the community. In your opinion, would that be worth the effort?
Please REDO! Yes Dustin. Even if I now speak on behalf of the community. The DAX functions you've covered is interesting and fits in with the overall theme you had going there. Now that's what you call a proper Power BI Introduction. The visuals as well speaks to the data and represents it quite well. I'm looking forward to your next installment. THANK YOU for your dedication in contributing to the success of the Power BI Desktop app!
I think for me personally, Financial samples showing products, units sold, manufacturer, sales price, gross sales, profits would work. I do not work with Finances, but think it's great to use them in Power BI. Seems to me one can be more flexible with visuals and DAX functions. Thanks for following up Dustin!
Is there anyway to create a dashboard just on Power BI Desktop for in house sharing? Or must all dashboards be published before you can link the visualizations to reports
This video is so nice gives me good understand about Power Bi in very short time also requesting to post the advanced topics in PowerBI.. Thanks a lot :)
Hi Dustin. Your work is fenomenal. I saw this days your report in PowerBI about NFL. You should make a vide explaining how you did that. Thanks for the tips.
Deployment / Publishing Do we have to do only at PowerBI website or my company can have it;s own Power BI server or Can we publish on to MS SQL Reports Server? Appreciate your reply and guidance. Wish you good luck!
Great Work Dustin!! Could please assist me with below question:- How to connect SAP BO Universe In power BI desktop? How to Create Alias In Power BI Desktop? Does Power-BI has any restriction on the number of columns & Rows while Importing? How is Report Performance in Power BI if number of users are more ? Thanks,
+JavierII Gonzalez There's a couple different ways to share content in the Power BI service (app.powerbi.com). You can share a dashboard by right-clicking the ellipses next to the dashboard and clicking share. You can also share content through Content Packs, which you can read about here: powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-packs-introduction/ I hope this helps. :)
+JonnyTeronni You can use the free Power BI desktop download to get started but if you want to deploy your Power BI reports and share them you'll need the Power BI site which requires the appropriate Office 365 subscription.
Hey Dustin, wonderful video. Thank you for your excellent intro. I have a query, say if i publish the report to P.B service , how is the data secure on cloud? How reliable is it then ?
+carlos Not to my knowledge. You can, however, view the Power Query code being generated: sqldusty.com/2015/08/10/cleaning-your-powerbi-power-query-code/
Hello, I just learned about PowerBI today. I have *Office 2010 32 bit installed on Windows 7 Pro 64 bit. I just downloaded 64 bit Power BI* (the Microsoft website chose it for me). I have not installed PowerPivot but I do have the 32 bit 91.0MB MSI installer. *Can I use PowerBI with my Office 2010 32 bit?* Thanks in Advance.
Hi Dustin....You made the video that I needed. When are you posting more videos? You created the reports but you didn't pin any of the report to the dashboards on POwerBi website. Would be cool if you do that. Can you do a video on connecting to the SQL server and create a report from there? Thanks Dustin. I will be visiting your blog now.
+Iñigo Mazo There's not an easy way to drill down to the details. At this point Power BI isn't optimized for displaying the detail data. The latest version of Power BI does provide drill down functionality but not to the most granular level of data. When you deploy a Power BI model to your Power BI site, however, the data source is deployed so that users can create their own reports. This may give your users the ability to view the data as they wish which may answer some of their business questions.
Nice job Dustin. Is there a demo using date pulled from wikepedia? This tool just blew my mind. It will be so helpful for so many researchers in many areas. Thank-you again Dustin.
+Mark Chinsky The Power BI Enterprise Gateway is used to administrate connections between the Power BI Service and the on-prem data sources. You can read more about the Power BI gateways here: powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/
Power BI Desktop is the desktop authoring tool used to create content. Power BI refers to the service that runs in Azure used to distribute the content, allow collaboration and creation. Power BI Desktop publishes to the Power BI service where the published content is viewed and shared. Hope this helps. :)
![Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡](http://i.ytimg.com/vi/5X5LWcLtkzg/mqdefault.jpg)
i'm trying to share an excel workbook exported from power bi (from analize in excel tab) with other co-workers, but i can't get it done, is there any way to do it? am i missing something? (i'm using the 60 days pro trial)
Good morning, friends. I'm loving the new #PowerBI desktop. Anyone else addicted to building #dashboard reports in Power BI? #businessintelligence FTW!
Fantastic Video Dustin . Really help full
I am using latest version of power BI and enjoying preparing different reports, analysis and Dashboards as well. All these documents are very easy to make on Power BI.
Hello, Dustin! Thank you for the video, it was quite useful. I am using PowerBI in order to make financial reports and I needed some light.
moving the mouse erratically really drove me crazy!! nice work, thanks for sharing :)
I'll work on my mouse skills. :) Glad you found it helpful.
Thanks Ryan! Excellent stuff, looking forward to install it and generate some meaningful reports
That's a really cool demonstration Ryan. I can't understand why someone would give it the thumbs down.
Imparting your knowledge to others very nicely, which helps everyone to start on this
Investing this app for a business unit that requires reporting from excel files. I think it might be a winner!
I've just started using this Power Bi and this video is brilliant.
Thank You
John Bowman-Yard You're welcome!
Hello Dustin,
Thanks a lot, this is very good video for beginners.
I am experienced guy into MSBI development. Now I want to learn POWER BI, this is my first video to start.
After your video I can start build my own dashboard, very practical and useful guide. Thanks.
+Lixia Zhang You are most welcome!
Great presentation.
Been doing DW/DM/BI For over a decade and found your tutorial very useful.
I think after this tutorial, I can work on my own without any additional help.
Thanks Dustin for a great introduction on how to use PowerBI. Brilliant!
Great work Dustin.Thanks for all the detailed info
+Hector Marcia Thank you, Hector! Glad you found it useful!
It's Very helpful and Nice Presentation
Very nice introduction to PowerBI. I hope to completely watch it but the first fifteen minutes were definitely interesting and useful. Thank you!
Ll
Llll
L
Really cool, thanks for this walk through, looking forward to playing with it
Very well explained. Awesome job Dustin.
Superb.. Good walk thru!!!! Thank you!
Thanks & well done Dustin. Perhaps at a later version you have talked about how the data can be updated?
Thanks Dustin. Very useful and learnt quite a lot. Specially the DAX stuff.
@Dustin Ryan, thanks a lot for your insightful video. you just made clear to me the relationship between Power BI desktop and Power Pivot. I learnt a lot and also connected the missing dots by watching your video
Great, glad you found it helpful.
Great Demo, Thanks for taking time, uploading and explaining in detail end to end.
That's really a nice tutorial.. From this i have learnt what power bi can do. Thanks.
Walk through an introduction to the #PowerBI Desktop with Dustin Ryan. In this video you'll learn to import data, apply transformations and formatting to the data, build a dashboard report with multiple chart types, format the reports, and then publish the report to your Power BI site. #businessintelligence #msbi
Great intro. Clear and to the point. Thanks!
Dustin, I really liked your video. I've worked as a Microsoft Trainer for a few years and also consulting with SQL Server. You were very easy to follow and understand. I have also worked with QlikSense and QlikView. It seems that his product does a lot of the same type of stuff. I wanted to be able to talk about the product if someone asks me and with your video, I can more than do that. Thanks for putting it up :)
I never seen this type of report video which is really amaze
Hi Dustin. Must confess one the better Intro vids for Power BI I've come across! Like your sample data and how you used it to it's full capacity. Worthwhile signing up to Opusdata to get that sample file. Thanks, keep up the good work!
Thanks, Leon. I'm glad you enjoyed it. I've been toying with the idea of redoing the video with a more publically available dataset that I made available for download. I don't normally like to redo what I've already done, but I would if it was beneficial to the community. In your opinion, would that be worth the effort?
Please REDO! Yes Dustin. Even if I now speak on behalf of the community. The DAX functions you've covered is interesting and fits in with the overall theme you had going there. Now that's what you call a proper Power BI Introduction. The visuals as well speaks to the data and represents it quite well. I'm looking forward to your next installment. THANK YOU for your dedication in contributing to the success of the Power BI Desktop app!
Thanks for the feedback, Leon. It's very helpful to me personally. Any suggestions for good datasets to use?
I think for me personally, Financial samples showing products, units sold, manufacturer, sales price, gross sales, profits would work. I do not work with Finances, but think it's great to use them in Power BI. Seems to me one can be more flexible with visuals and DAX functions. Thanks for following up Dustin!
Ok cool, I can probably find some data based on retail data that fits that criteria.
That was really helpful Dustin. Great job!
Looking forward to advancing my career through Power Business Analytics in Excel, Microsoft BI, Tableau and Qlik
Thanks, very nice straightforward intro !
Great video, thank you! This makes me want to play with this software! Hardest part is just finding something to use :D
Is there anyway to create a dashboard just on Power BI Desktop for in house sharing? Or must all dashboards be published before you can link the visualizations to reports
Good introductory to beginners like me! Thanks!
This is one of the best BI intro video
Thank you
You're welcome! Glad it was helpful. :)
This video is so nice gives me good understand about Power Bi in very short time also requesting to post the advanced topics in PowerBI.. Thanks a lot :)
Neat little video Dusty, good introduction. Thanks :-)
Great work Dustin. Thnak you very much for sharing you knowledge.
Hi Dustin. Your work is fenomenal. I saw this days your report in PowerBI about NFL. You should make a vide explaining how you did that. Thanks for the tips.
Thanks Ryan. Excelent presentation and great explanation. Greetings from Buenos Aires
+Sebastian Molero Thank you! Glad you found it beneficial!
This is great. It was indeed helpful to my career in Power BI
Hello, what software are you using for the presentation which automatically draws arrows and switchs to drawing pen?
Great video! Very informative first introduction to PowerBI!
Dear Sir,
What should be the minimum hard ware requirement for running Power BI, for the speed which we can see in published Power Bi videos...?
Hi Dustin!! Thanks for such an informative session.
You're welcome! Glad you found it helpful!
Hello, great intro video. Do you know where I may download the data files used in presentation? Thank you!
thanks for the video i was knowing nothing about power bi but now m sure i know much.
You made it look so easy. It was indeed very clear. Thank you!!!! Just love building #dashboard.
It's really very good video for beginners. Thank you
Is there any way to change the position of X-axis in a cluster bar chart, by default it's position down but i wanted to on upper side of chart.
Thnx Dustin that was good. Is the data getting externalised when you publish. If yes how to create a URL that is only internal to an org
Great demo .... would be glad if you can give some pros/cons in relation to tableau.. 😊
great video for a Power BI beginner, thank you
You're welcome! Glad you found it useful!
Hi Dustin, just have a doubt, can i share/publish a Power BI report tru a corporate MS SharePoint?
How can we achieve the conditional COLOR formatting of Line chart based on some rules in power bi ?
Awesome video. Thanks Dustin!
Great! Many Thanks! But same question as Yehudit Mahalal.
Great video! Very informative and easy to understand!
really good exposure on Microsoft power Bi..!
Thanks for sharing this .
Thanks for this tutorial. It was very useful
Deployment / Publishing
Do we have to do only at PowerBI website or my company can have it;s own Power BI server
or
Can we publish on to MS SQL Reports Server?
Appreciate your reply and guidance.
Wish you good luck!
Liked and useful Dustin. Thanks for this.
Great Work Dustin!!
Could please assist me with below question:-
How to connect SAP BO Universe In power BI desktop?
How to Create Alias In Power BI Desktop?
Does Power-BI has any restriction on the number of columns & Rows while Importing?
How is Report Performance in Power BI if number of users are more ?
Thanks,
Hi Ryan ,hope youre doing well, how can i share a report to my boss? I created a dashboard but i cant see any information on it :(
+JavierII Gonzalez There's a couple different ways to share content in the Power BI service (app.powerbi.com). You can share a dashboard by right-clicking the ellipses next to the dashboard and clicking share. You can also share content through Content Packs, which you can read about here: powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-packs-introduction/ I hope this helps. :)
Hi Dustin, can I use Power BI Desktop on my company only for intern dashboards with the free download?
+JonnyTeronni You can use the free Power BI desktop download to get started but if you want to deploy your Power BI reports and share them you'll need the Power BI site which requires the appropriate Office 365 subscription.
Hi Ryan, I want to connect Power BI desktop to SAP BI system and get data into power BI. Can you please help me in this.
Hey Dustin, wonderful video. Thank you for your excellent intro. I have a query, say if i publish the report to P.B service , how is the data secure on cloud? How reliable is it then ?
Could be possible to get the data model or the excel sheet to do the exercise with the video, please? Thanks !
I want to thank you for a very good tutorial.
Thank you Dustin the video was very helpful..
Thanks
Good job!!Thank you for clear explanation.
Thank you Dustin! Great intro video. I was just curious if there's a way to see the code generating the reports.
+carlos Not to my knowledge. You can, however, view the Power Query code being generated:
sqldusty.com/2015/08/10/cleaning-your-powerbi-power-query-code/
Really this is awesome power BI tutorial thanks and appreciable.
Good video, but the DateAdd function for the previous year isn't working in the current version of the tool it seems.
Thank you, an amazing walk through PBI
Thanks a lot for this insightful video.
Thanks Dustin Very informative
Awesome Ryan, thank you so much for nice and understandable explanation. It is really very informative. Thanks again !
Satish
You're welcome! :)
Hello, I just learned about PowerBI today. I have *Office 2010 32 bit installed on Windows 7 Pro 64 bit. I just downloaded 64 bit Power BI* (the Microsoft website chose it for me). I have not installed PowerPivot but I do have the 32 bit 91.0MB MSI installer.
*Can I use PowerBI with my Office 2010 32 bit?*
Thanks in Advance.
Great video, thanks Dustin ;)
great video.....how can we make paramater like tableau in powerbi
Very useful. I learned a great deal from you!
Hi Dustin....You made the video that I needed. When are you posting more videos? You created the reports but you didn't pin any of the report to the dashboards on POwerBi website. Would be cool if you do that.
Can you do a video on connecting to the SQL server and create a report from there?
Thanks Dustin. I will be visiting your blog now.
GREAT VIDEO DUSTIN
THANKS
+Nelson Castillo You're most welcome! Thanks for watching. :)
That was very helpful. Thanks
Dustin, can you add custom filter like last year, last month
Very helpful video. Thanks :)
And how can you show a detailed report from clicking in a component of the dashboard?
+Iñigo Mazo There's not an easy way to drill down to the details. At this point Power BI isn't optimized for displaying the detail data. The latest version of Power BI does provide drill down functionality but not to the most granular level of data.
When you deploy a Power BI model to your Power BI site, however, the data source is deployed so that users can create their own reports. This may give your users the ability to view the data as they wish which may answer some of their business questions.
Dustin, what program are you using to write to your screen?
It's called ZoomIt. It's a free download. Just do a search for ZoomIt.exe and you'll find it.
Dustin Ryan
Thanks Dustin.
Very handy. Thanks for sharing.
Nice job Dustin. Is there a demo using date pulled from wikepedia? This tool just blew my mind. It will be so helpful for so many researchers in many areas. Thank-you again Dustin.
very very nice! Thnaks for doing this.
Thank you! this video was very informative :)
Thanks Dustin. It is a great video
Thanks, great video. Once you published it, how does it update the data if the source is a local spreadsheet or SQL Database? Is it automatic?
+Mark Chinsky The Power BI Enterprise Gateway is used to administrate connections between the Power BI Service and the on-prem data sources. You can read more about the Power BI gateways here: powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/
Great video!! One quick question, Power BI vs Power BI desktop, what's the difference?
Power BI Desktop is the desktop authoring tool used to create content. Power BI refers to the service that runs in Azure used to distribute the content, allow collaboration and creation. Power BI Desktop publishes to the Power BI service where the published content is viewed and shared. Hope this helps. :)
+Dustin Ryan Got it. Thanks for prompt reply :)
Thank you so much I'm living in Iran and you did help me !