Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications

    Microsoft Links Power Query, Salesforce for Better Business Insights

    By
    Pedro Hernandez
    -
    November 26, 2014
    Share
    Facebook
    Twitter
    Linkedin
      business intelligence

      Microsoft’s partnership with Salesforce has officially expanded into the realm of business intelligence and analytics.

      First teased during the DreamForce conference last month, Microsoft has issued an update for Power Query that enables users to explore Salesforce data. Backed by Microsoft’s Power BI technology, Power Query, as its former code name “Data Explorer” suggests, allows users to quickly discover and extract business insights using Excel.

      Now Office 365 users can plumb the depths of their Salesforce data for business insights, announced Microsoft.

      “This month we’re including the Salesforce connector as a mainstream Power Query feature,” said Miguel Llopis, a Microsoft Power BI program manager, in a statement. The feature, part of a batch of November 2014 updates for Power Query, “allows customers to connect to their Salesforce accounts and import data into Excel.”

      The software establishes a one-way connection, alleviating concerns that an organization’s Salesforce data may end up altered. In a related blog post, Microsoft explained that “Power Query connects on behalf of the user and only has access to the user’s data. The Salesforce API is used in a read-only manner, letting users access the data without making changes.”

      Power Query then gives users the option of importing data directly from Salesforce objects or reports built in the cloud business software.

      Selecting the Salesforce objects option, which connects to underlying object tables, “displays a full list of all objects to which the user has access. Users can choose one or more tables and import them into the workbook,” stated to the company. Leveraging the Reports API, the latter option “lets users access data in a form similar to what they see in Salesforce, without having to connect to the underlying objects and rebuilding these views on top.”

      Organizations can then add more data sources to the fray. “Once in Excel, users can combine their Salesforce data with other relevant data using the wide range of connectors available in Power Query,” stated the company.

      Joining the Salesforce integration is a new SQL Server Analysis Services connector. The “commonly requested” and long-awaited connector “provides exploration, transformation and import capabilities on top of AS cubes,” stated Llopis.

      Also new is the ability to disable or customize “the column name prefix for columns generated by an Expand Column operation.”

      A checkbox appearing under the Expand Column dropdown menu gives users the option of opting out of the prefix. “Before this update, new columns would contain the original column name as prefix and users not wanting this prefix would have to manually remove it from each column afterwards (either via Column Rename or by modifying the generated Expand Column formula),” Llopis said. A new field in the Expand Columns dialog box permits prefix name changes.

      Rounding out this month’s Power Query updates is an expanded Query Editor File menu and an Advanced Editor context menu item that provides quick access to the feature while working with multiple queries in the Query Editor.

      Pedro Hernandez
      Pedro Hernandez is a contributor to eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

      MOST POPULAR ARTICLES

      Big Data and Analytics

      Alteryx’s Suresh Vittal on the Democratization of...

      James Maguire - May 31, 2022 0
      I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×