How to Connect Smartsheet to Power BI | Part 2: Creating More Complex Visuals
Now that we've got our Smartsheet Data source imported to Power BI, it's time to build some visuals!
In Part 2 of our Power BI to Smartsheet series, Caroline demonstrates how to work with your Smartsheet data set to create more complex visuals, adjust formatting and filters, gain helpful insights from your data set, and publish the visuals for easy visibility across a team.
Make sure to watch her two use cases for using Power BI in project management: viewing projects per consultant, and projects per client!
To connect Smartsheet to Power BI, you can use the Smartsheet connector available in Power BI Desktop. Here's a step-by-step guide:
Open Power BI Desktop: Launch Power BI Desktop on your computer. If you don't have it installed, you can download it from the Microsoft website.
Get Data: In Power BI Desktop, click on the "Home" tab in the ribbon menu, and then click on "Get Data" in the "External Data" group.
Select Smartsheet Connector: In the "Get Data" window, search for "Smartsheet" in the search bar or locate it under the "Online Services" category. Click on "Smartsheet" and then click "Connect."
Authenticate: Power BI will prompt you to sign in to your Smartsheet account. Enter your credentials (email and password) and click "Sign In."
Choose Data: After successful authentication, you'll see a navigator window displaying your Smartsheet workspaces, sheets, and reports. Navigate through your Smartsheet account structure and select the data you want to import into Power BI. You can choose one or multiple sheets/reports. Click "Load" when you're ready.
Transform Data (Optional): You can perform data transformations using Power Query Editor before loading the data into Power BI. This step allows you to clean, filter, or reshape the data as needed. Click on "Transform Data" to open Power Query Editor.
Load Data: After transforming the data (if necessary), click on "Close & Load" to import the selected data into Power BI.
Visualize Data: Power BI will load the data into the data model, and you'll be directed to the report view. Here, you can create visualizations, reports, and dashboards based on your Smartsheet data.
Refresh Data: To keep your Power BI reports up to date with changes in your Smartsheet data, you can configure scheduled refreshes. Click on "Home" in the ribbon menu and then click on "Schedule Refresh" to set up automatic data refreshes.
That's it! You've successfully connected Smartsheet to Power BI, allowing you to analyze and visualize your Smartsheet data within the Power BI environment.
(Missed part 1 of this series? Find it here: https://youtu.be/zJYArKZT3Ho)
Highlights:
0:00 Picking up from Part 1
00:47 Creating a Bar Chart
1:50 Use Case: Projects per Consultant
3:00 Formatting Your Visual
6:19 Dealing with Blanks in Your Data Set
7:52 Use Case: Projects Per Client
14:14 Exploring Formatting Options
16:11 Publishing Your Visual
ā”ļø Resources for You:
Our Website - https://echoprojectmanagement.com/
Meet with Us - https://www.echoprojectmanagement.com/schedule-meeting
Our LinkedIn - https://www.linkedin.com/company/echo-consulting-pm/
Subscribe Here: https://www.youtube.com/c/EchoConsulting?sub_confirmation=1
ā”ļø Recommended Playlists:
Microsoft 365 Tutorials & Tips ā https://www.youtube.com/watch?v=meWGjWvNc3Q&list=PLO3D1ido-Qg7i3llBtnGkWI_rOF1x-r3V
Smartsheet Tutorials & Tips ā https://www.youtube.com/watch?v=DQazpDmRWis&list=PLO3D1ido-Qg6eBqKtnAtWk3iJS_-mpyiX
Monday.com Tutorials & Tips ā https://www.youtube.com/playlist?list=PLO3D1ido-Qg4aMalxkqUNRML-iB387tqu
Asana Tutorials & Tips ā https://www.youtube.com/playlist?list=PLO3D1ido-Qg783975SGf7SIW0AtH6VASs
ClickUp Tutorials & Tips ā https://www.youtube.com/watch?v=7rCwzCVSP7I&list=PLO3D1ido-Qg6X1Mv27JAgxCm17xxbauvM
Project Management ā https://www.youtube.com/watch?v=ozVgrvT9BlU&list=PLO3D1ido-Qg7P_Cxs2CAIm6dW55LNPpKf
Webinars ā https://www.youtube.com/watch?v=n2LH1Gytj5g&list=PLO3D1ido-Qg4Evvvww8gtUgVgc05f2Qup
SEO HASHTAG:
#How,
#ConnectSmartsheet,
#PowerBI,
#Part2,
#Creating,
#ComplexVisuals,
#connect_to_smartsheet,
#power_bi_tutorial,
SEO TAG:
power bi,connect to smartsheet,smartsheet,connect smartsheet to excel,how to power bi,how to use power bi,introduction to power bi,write to power bi,smartsheet power bi,power bi and smartsheet,smartsheet and power bi,connect smartsheet to sql server,how to connect google sheets to power bi,power bi tutorial,power bi training,power bi for beginners,Power BI,Power BI and Smartsheet,Smartsheet and Power BI,Smartsheet Power BI,MS 365 Power BI,MS 365,Microsoft 365,Microsoft,pmo manager,power bi videos,power bi demo,power bi,smartsheet,power bi and smartsheet,smartsheet and power bi,power bi tutorial,power bi training,Creating More Complex Visuals: Echo Consulting,Complex Visuals: Echo Consulting,Power BI: Echo Consulting,creating more complex visuals: echo consulting,complex visuals: echo consulting,BI