A couple of months ago, we launched a new Power BI integration for visualizing SharePoint lists for all Targeted release users. We’re now excited to announce that the experience has rolled out to Standard release users and is now accessible to everyone!
You can check out this video from the original launch or read on to get a high-level overview of the feature.
https://www.youtube.com/watch?v=okkdghpTF9c
This experience empowers SharePoint list and Microsoft List users to easily explore your data. With just a couple of clicks, you’re able to go from looking at a list of data to interacting with an auto-generated report. You’ll find this new option under the Integration menu on any list.
Visualize_the_list_button_found_in_the_command_bar_under_the_Integrate_split_but
Once you select Visualize in Power BI, a new tab will open the automatically generated report, which you can then further customize and publish back to the list.
Auto_generated_report_with_several_fields_selected_in_the_summarize_pane
The reports you save and publish back to the list are not visible within the Power BI service. Instead, to make it easy for other list users to find, you’ll find these published reports within the same Integrate menu of the list.
Integrate_menu_in_SharePoint_showing_the_previously_shared_report
For all the details of the feature, be sure to check out our documentation.
Lastly, if you're interested in having a report automatically created for you, but you don't have data within lists, don't forget you can similarly automatically generate reports within the Power BI service just by copy and pasting data.
Microsoft Employee