cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

What Happened To "Allow unrestricted measures in DirectQuery mode"

I just installed the July 2018 release and under Options/DirectQuery, there is no longer an option for "Allow unrestricted measures in DirectQuery mode."

 

I only see "Treat SAP HANA as a relational source."

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power BI Team
Power BI Team

With composite models, this "unrestricted measures" is implicitly on.  Since there is nothing to choose, we have removed the checkbox from the options dialog if you have turned on the Composite Models preview option.

 

View solution in original post

3 REPLIES 3
Highlighted
Power BI Team
Power BI Team

With composite models, this "unrestricted measures" is implicitly on.  Since there is nothing to choose, we have removed the checkbox from the options dialog if you have turned on the Composite Models preview option.

 

View solution in original post

Highlighted
Anonymous
Not applicable

Hello,

 

I am still not able to utilize a format function? 

 

Error: Function 'FORMAT' is not allowed as part of calculated column DAX expressions on DirectQuery models.

 

Thanks,
Brady

Highlighted

Sorry can I just say that this was an absolutely terrible response to his question, he never said he was using composite reports in the first place and we may not want to use composite reports. Why would you remove this option for purely direct query reports? We might not want to use a composite report.

 

What is wrong with Microsoft? Why do make so many decisions like this without common sense?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors