live connection

When I want to connect live to a SSAS cube I don't get the option, the choise is almost jumping to IMPORT DATA instead of LIVE CONNECTION. Any idea how to solve this ?

power bi

3 Comments

BB
Regular Visitor
6 years ago
Try providing Cube Name (explicitly) in Database(optional) field then select - connect live
mib1
New Member
6 years ago
First of all you have to have a SQL Server 2012 SP1 CU4 or newer. Second it does not support SQL server standard edition on SQL2012 and SQL2014. In this case you need to have a Enterprise or a Business Intelligence Edition of the SQL server. Live connection is supported for standard edition of the SQL2016.
fbcideas_migusr
New Member
1 year ago
Status added:
New

Recent ideas

Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...
vvargasv
Microsoft Employee
8 hours ago
New
Views
0likes
Comments
Conditional Formatting on Matrix Rows
Currently, the matrix visual only supports conditional formatting on a per-field basis. If you want to apply the same formatting for an entire row of values you need to set it once for each field, an...
wcarter
Advocate III
11 hours ago
New
Views
0likes
Comments
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...
Jarrinf
Frequent Visitor
14 hours ago
New
Views
3likes
Comments
Add REST API to Take Ownership of Fabric Pipelines
When using service account to automatically deploy Fabric pipelines from Dev workspace to upper environments, the owner of pipelines in target envionment remain unchanged. In some situations, per...
VickyPeng
Regular Visitor
18 hours ago
New
Views
5likes
Comments
Update the 'Users can set up email subscriptions' in Fabric Admin Portal to specific groups
I want to be able to allow a specific group of users to set up email subscriptions. In my admin portal view I only get the following Can this be updated to allow specific user groups? ...
Chart68
New Member
20 hours ago
New
Views
1like
Comment

live connection

Dynamic current-period defaults for separate Year and Month slicers

Conditional Formatting on Matrix Rows

About "Download SQL database project" and fix the downloaded project

Add REST API to Take Ownership of Fabric Pipelines

Update the 'Users can set up email subscriptions' in Fabric Admin Portal to specific groups