Therre is a design flw/bug with the listdata.svc Rest API that is impacting Power Queries ability to filter large SharePoint lists. Filters on indexed date columns do not use index -- they get the whole LIST. One of the most common filters on an operations dashboard is based on modified date.!!!
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Support Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi15 minutes agoMicrosoft EmployeeNew9Views3likes0CommentsAuto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv2 hours agoNew MemberNew5Views1like0Comments