Dynamics CRM Online customers can easily load their data into excel, with the new Power Query Microsoft provided last December.
Power BI offers users to connect with data
It already enabled users of Office and Office 365 to query and analyze data, but this update lets the Power BI suite of tools reach the fastest growing portion of the Dynamics CRM customer base. After pouring the ‘power of the cloud’ into excel using the OData feed, visualisations can be made using Power View. This offers lots of new possibilities for users to connect with data.
Users get access to SharePoint Online-site
With Power BI for Office 365 users get access to SharePoint Online-sites via an app. Here it is made easy to share Excel-files and use BI capabilities, including a special visual and interactive BI interface.
It offers enhanced and enriched presentation
The Excel-files from the standard library in SharePoint can be used on the Power BI Site, which offers enhanced and enriched presentation of these files. Erasing a file from the Power BI-site, also deletes it from the SharePoint library. The app can be downloaded after subscribing to Power BI for Office 365 Preview. Source: www.microsoft.com.
Additional and more up-to-date information on this BI-tool and Power BI is available in our Business Intelligence Tools Survey 2019.