**UPDATE**: It is not possible to refresh custom connectors on the service and, there is now a Google Analytics connector on Power BI Desktop.
Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW
Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139
Let’s do a small recap before we continue: we have talked about Power BI Desktop, which is the tool that you use to create your report. We have talked about Power BI Service which is the place where you publish your report and you share it with others. We have talked about Power BI mobile which gives you the possibility to see your report on iPhones and tablets, on iOS windows and Android.
What we’re going to talk about today is Power BI for developers. Power BI gives you the possibility to customize the system to fit your needs.
Power BI for Developers, main components
There are four main components for that.
Power BI embed
The first one is Power BI embed, that means that you can get the Power BI reports that you have published on the Service and put them somewhere else. You can put them in your apps, you can put them in your systems, you can put them in your applications.
You can just embed them somewhere else and allows you to have access to them outside of Power BI dot-com, the Service.
This is quite useful if you have a BI platform where you would like to publish your report or you would like to have them on Teams, on SharePoint (this is a much easier embed but still). That is the first component.
Power BI custom visuals
The second component I want to talk about is the possibility to create your own visuals.
Power BI Desktop comes with a set of visuals that are the most common ones: you have the line charts, bar charts, column charts, Maps, the normal ones, but there is a marketplace, office marketplace where you can download visuals that somebody else has done and there is a third option, which is what is included in Power BI for developers, and is that you can create your own custom visual.
If your organization or you have specific visualization that you love and that you would like to have it but it’s not available anywhere, you can create it yourself.
You use some packages from JavaScript and then you can create it and you will use CSS to style the custom visual, so extremely useful if there is something you specifically want to have.
Power BI custom connectors
The third option is to create your own custom connectors and this is absolutely fantastic!
Again, Power BI Desktop and Power BI Service, they come with a set of custom connectors or connectors. You know you can connect to Azure, you can connect to SQL on-prem, you can connect to Google Analytics (on the Service only not on Desktop).
Let’s say that you would like to connect to Google Analytics on the Desktop, how do you do that?
If you create a custom connector for Google Analytics Power BI Desktop and you import it into Power BI Service, you won’t be able to schedule refresh them just yet. It will come but not just yet, so there are a few limitations to that, but still, you can access your data in Power BI Desktop with those custom connectors easier than the typical export to excel and have an excel file somewhere else and then don’t really know what data is what. You can connect directly with the system with your own code and make sure the data is available in Power BI, really fantastic!
Power BI REST API
And the last option for Power BI developers that I want to talk about today, is the Power BI REST API.
The Power BI API allows you to send data from your systems to Powerbi.com directly so you can stream live data into Power BI. It is very useful!
Hopefully that gives you a better overview of what you can do as a developer in Power BI.
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
https://www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin: https://goo.gl/3VW6Ky
Twitter: @curbalen, @ruthpozuelo
Google +: https://goo.gl/rvIBDP
Facebook: https://goo.gl/bME2sB