Power BI does not currently provide the ability to run pass thru SQL functions on data, but Tableau does. Pass thru functions allow the ability to run SQL operations directly on the database without the operation being interpreted by the BI service. http://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_functions_passthrough.html
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Add "Add to Dictionary" and "Ignore All" Functionality to Power BI Text Boxes
When creating professional Power BI reports, legitimate company names, project names, industry-specific terms and technical terminology are sometimes incorrectly flagged as spelling errors with a red...mmartelozzo6 hours agoNew MemberNew4Views0likes0CommentsFix Direct Lake semantic model binding in Deployment Pipelines
When deploying Direct Lake semantic models via Deployment Pipelines, the Lakehouse source is incorrectly treated as an external SQL source. This results in broken lineage and prompts for credentials....lk12316 hours agoAdvocate INew1.5KViews27likes2Comments