Had a great week after conducting two-day sessions on Data Warehousing and How to do Business Intelligence with Microsoft Power BI. During the sessions, I got an interesting question from the audience. The question was “how its possible to show the Power BI report or visuals in my Powerpoint slides, at the same time the data need to be up-to-date same as in report”. I love these sort of questions and find solutions because these are real-world problems they have. I thought to write a simple post to address that problem, and in this post, I explain how to achieve it.
Pre-requisites
You have already Power BI report created and published to the Power BI service. If you missed how to do it read this blog. If your source is a file like Excel or CSV the deployment is even simple. You don't want to worry about to configure the gateway and you can simply click Publish and publish your report.
Steps to Follow
Open the MS PowerPoint and go to Insert tab and My-Addins
It will open the Office Add-ins marketplace. Search for PowerBI. You will see an addin Power BI Tiles. Click the Add button and install it in your PowerPoint. (this is a custom Addin by PowerBITiles)
Once you installed the add-in will be like this in your PowerPoint slide. In this case, you have to choose either from Power BI or from a Public report. In here I'm selecting From Power BI report option because I want to see my pre-deployed report content to see in my PowerPoint.
It will open the Web browser and ask you to provide AD credentials to sign-in to the Power BI service.
Next window, its ask to authorize to perform a set of actions as below. Basically, view reports datasets and the content you have in your PBI service.
Once you accept, it will close the browser window and ur PowerPoint add-in will start to display the Dashboards and reports content you have in your service. Woooaaah !.. is it this much simple. Hmmm!
Next stem, you know, the only thing you have to do, select the dashboard or report you want to display in your PowerPoint slide.
I selected one of the simple report I did to visualize attendance for a conference from various locations around the globe.
It is wonderful, Because, it is interactive same as other PowerBI reports. So, this gonna be an awesome way to present your analysis to your clients or top management.
There is an option to apply filters below. However, it did not work properly in my environment.
Similarly, in the bottom menu, there is an option to refresh data. I have to give a try a full round of refresh the data in the source, then my Power BI report and refresh the PowerPoint Addin finally. Hope you enjoyed this by learning how to use PowerBI addin to visualize your power BI report content in the PowerPoint. Please leave a comment below what do you think on this option and how it worked for your scenario. I'm happy to hear. Cheers! 😊
You have already Power BI report created and published to the Power BI service. If you missed how to do it read this blog. If your source is a file like Excel or CSV the deployment is even simple. You don't want to worry about to configure the gateway and you can simply click Publish and publish your report.
Steps to Follow
Open the MS PowerPoint and go to Insert tab and My-Addins
It will open the Office Add-ins marketplace. Search for PowerBI. You will see an addin Power BI Tiles. Click the Add button and install it in your PowerPoint. (this is a custom Addin by PowerBITiles)
Once you installed the add-in will be like this in your PowerPoint slide. In this case, you have to choose either from Power BI or from a Public report. In here I'm selecting From Power BI report option because I want to see my pre-deployed report content to see in my PowerPoint.
It will open the Web browser and ask you to provide AD credentials to sign-in to the Power BI service.
Next window, its ask to authorize to perform a set of actions as below. Basically, view reports datasets and the content you have in your PBI service.
Once you accept, it will close the browser window and ur PowerPoint add-in will start to display the Dashboards and reports content you have in your service. Woooaaah !.. is it this much simple. Hmmm!
Next stem, you know, the only thing you have to do, select the dashboard or report you want to display in your PowerPoint slide.
I selected one of the simple report I did to visualize attendance for a conference from various locations around the globe.
It is wonderful, Because, it is interactive same as other PowerBI reports. So, this gonna be an awesome way to present your analysis to your clients or top management.
There is an option to apply filters below. However, it did not work properly in my environment.
Similarly, in the bottom menu, there is an option to refresh data. I have to give a try a full round of refresh the data in the source, then my Power BI report and refresh the PowerPoint Addin finally. Hope you enjoyed this by learning how to use PowerBI addin to visualize your power BI report content in the PowerPoint. Please leave a comment below what do you think on this option and how it worked for your scenario. I'm happy to hear. Cheers! 😊
This comment has been removed by the author.
ReplyDeletevery nice and provide me informative content thanks for sharing for more information Looking for the best Business Intelligence reporting Services
ReplyDelete