Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Power BI Gateway Connection to SQL 2014 Analysis Services Tabular model

Posted on by 4

Details

On Premises Data Gateway Edition Version: 13.0.1500.486

SQL 2014 Edition  Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Standard Edition (64-bit) <X64> (Build 9600: )

Issue

Power BI Gateway setups, connects and tests fine (two data sources SSAS first 100MB and 2nd 500MB)

But when we try sync either data source get the error "Data Source Access Error - Please contact Gateway Administrator"

Posts say to check UPN and the effective name from Azure AD to Domain seem fine

Started SQL Profiler and am seeing trace error below

"Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services"

 

Question

I have searched far and wide (https://powerbi.microsoft.com/en-us/pricing/) and blogs e.t.c.

But can find a min spec that says Power BI Pro users or Consuming Live Data Sources (On Premises Data Gateway)  - requires a minimum of SQL BI edition.

Am I missing something should SQL 2014 STD support this?

 

  • gfoskin Profile Picture
    gfoskin 4 on at
    RE: Power BI Gateway Connection to SQL 2014 Analysis Services Tabular model

    One further update looking at the Feature List in SQL 2016 - am I correct in saying the Business Intelligence features from SQL 2014 are now included in SQL 2016 Standard Edition

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans