Close
  • Latest News
  • Artificial Intelligence
  • 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
  • Artificial Intelligence
  • 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 Expands Power BI Report Server Data Source Support

    By
    Pedro Hernandez
    -
    August 29, 2017
    Share
    Facebook
    Twitter
    Linkedin
      Power BI Data Sources

      Microsoft has extended Power BI Report Server reach, allowing customer organizations to glean insights from a greater variety of business information.

      Debuting earlier this year, Power BI Report Server allows users to host reports created with the business intelligence and data visualization software on their internal networks. In June, Microsoft added the ability to use information imported from SQL Server Analysis Services data sources as a basis for those reports.

      Now, in the just-released August 2017 preview version of Power BI Report Server, the software giant has opened the floodgates.

      “With this August 2017 preview, users can create Power BI reports in Power BI Desktop that connect to any data source and publish their reports to Power BI Report Server,” wrote Microsoft senior program manager Christopher Finlan in an Aug. 26 announcement. “There’s no special configuration required to enable this functionality—simply install and configure the August 2017 preview version of Power BI Report Server on your machine, and you’re ready to go.”

      Users can link to their desired data sources using the Power BI Desktop application, which is generally used to configure dashboards, fine-tune data visualizations and author full reports. As with any early software, some compromises were made.

      Currently, the functionality in scale-out deployments of Power BI Report Server and Direct Query data connections are unsupported. Scheduled data refresh operations involving imported data are not available and reports using the feature cannot exceed 50MB. Microsoft hopes to lift these limitations when the product is made generally available sometime in the fourth quarter of 2017.

      As expected, the software allows users to view interactive, graphically-rich reports in a browser by logging into a web portal. The latest version now supports Excel workbooks, enabling users to view and interact with Excel data without launching the spreadsheet software. With its own data-transformation and number-crunching capabilities, Excel is often used as a companion tool to Power BI.

      The new Excel viewing feature requires the Office Online Server software, a separate download. It allows users to access workbooks that contain a PowerPivot data model, have a live connection to SQL Server Analysis Services data source or have no external data source dependencies at all, said Finlan.

      Organizations that also use Microsoft Dynamics 365, the company’s cloud-enabled customer relationship management (CRM) and enterprise resource planning (ERP) business application suite, the software maker has also released a Power BI template that provides improved visibility into their field service operations.

      “This template includes a set of reports designed for field service professionals. The solution template offers a very fast guided experience to create compelling reports on an extensible, scalable, and secure architecture and can be customized as needed,” stated Microsoft principal program manager Richard Tkachuk in a separate blog post.

      The Dynamics 365 Field Service Analytics template includes reports pending and completed work orders and completed work orders by customer with mapping functionality, among others. The template requires that customers use the free Dynamics 365 Data Export Service add-on.

      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.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      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.

      ×