Forum Discussion

Microsoft Employee

5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services. To learn more about this feature, please visit this blog post or our documentation. ...

General Comment

Anonymous

Not applicable

5 years ago

Some functions are not working.

Example, when I use "RELATED()" in a one-to-one relationship I'm getting the following error:

Relationship between tables:

The column was added on TF_Delivery_Header

Also, the calculate function and countrows are not working when creating columns:

The sorting of the fields on the main dataset is also gone:

My PBI version: 2.88.1385.0 64-bit (December 2020)

jeroenterheerdt

Microsoft Employee

5 years ago

is this a cross-source group relationship? If so, it is limited, and as such RELATED does not work. See RELATED function (DAX) - DAX | Microsoft Docs