Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Ingmar

mdx construct that is not allowed on DirectQuery Models

Submitted by on ‎12-19-2016 12:10 PM

Hello, I used the excel export function in PowerBi to create a view in Excel - I receive two errors:

MDX DirectQuery.PNG

 

1. MDX Error - see screenshot when adding a field - see screenshot

2. MDX Construct when adding the ActualsCD field - see screenshot

 

 

MDX DirectQuery II.PNG

 

Thank you - Ingmar

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎12-22-2016 12:54 AM

@Ingmar

 

When a model is in DirectQuery mode, it can only be queried by using DAX. You cannot use MDX to create queries. This means that you cannot use the Excel Pivot Client, because Excel uses MDX.

Please refer to Client restrictions part in https://technet.microsoft.com/en-us/library/hh230898(v=sql.110).aspx

 

Best Regards,

Herbert

Idea Statuses