Today we’re pleased to announce the addition of significant new features to both the Power BI for Office 365 and the Power Query add-in for Excel previews. Introduced in July and currently in preview, Power BI for Office 365 is a cloud based solution that reduces the barriers to deploying a self-service Business Intelligence environment for sharing live Excel based reports and data queries as well as new features that enable data discovery and information access from anywhere and from any device.
One of the Power BI features users have been most interested in is Q&A, which takes data exploration to a whole new level. With Q&A, users type ad-hoc questions and the system provides them with answers in the form of interactive charts and graphs. The search like experience is instantaneous and uses natural language query, interpreting the semantics of question the user is typing. We’ve received great responses from customers who have tested this capability on the preview sample data. Today we enable the ability to explore your own data with Q&A. You can add your own models to Q&A and begin to explore them with natural language query.
Try Q&A today by uploading your workbook to your Power BI Site. Do this by clicking on the add link and selecting “Upload file”. This will upload and enable your workbook for use in the Power BI site.
After your workbook has been enabled, click on the three dots on the thumbnail for your workbook and select “Add to Q&A”:
One you’ve completed these steps you can navigate to the Q&A question by clicking the “Search with Power BI Q&A” link in the upper right hand corner of your Power BI site:
Also, keeping in line with our goal to make Excel the only tool you need for data analysis and visualization, we are also excited to announce updates to the Power Query add-in for Excel preview, introducing new data source support and usability enhancements.
Connectivity to New Data Sources
Below is an example of a simple visualization created by connecting to your exchange account.
Automatic Detection of table relationships:
Transformations in the Query Editor:
Improvements to Search:
Finally, the Power BI team is excited to announce the launch of our updated website www.powerbi.com. The new site has a fresh new look and was designed with you in mind.
Here's a quick look at what's different:
We hope that you enjoy these new features and usability improvements. Don’t hesitate to let us know your thoughts through the forums and through the Smile/Frown feature.
Não estou conseguindo utilizar junto ao office 2013 365, como instalar e onde?
I installed the update but the synonyms button is not appearing in Excel, so Q&A is useless to me.
Tried to connect to Exchange and got this error - DataSource.Error: Exchange: Unable to contact Microsoft Exchange Autodiscover Service. Please make sure the Autodiscover Service is properly set up and your credential is valid.
Another feature useless to me.
I got the same Exchange error message as joe. I sent a frown email to support and got a reply saying it's an exchange issue you should speak to the exchange administrator. Duh! Like do i need to have the Exchange administrator do to fix the issue?
O365 Microsoft Exchange Connections do not work. I cannot connect to shared mailboxes, I cannot connect to my mailbox. I keep getting the same error. "The credentials provided are invalid"
I am not able to find a "How to" post/video on actually connecting to Microsoft Exchange through PowerBI.
Comments in this blog are open and monitored for each post for a period of two weeks after the posting date. If you have a specific question about a blog post that is older than two weeks, please submit your question via our Twitter handle @MSPowerBI