For Azure SQL Databases there is a very cool new preview feature: “sp_invoke_external_rest_endpoint “. This function allows you to call certain Microsoft API endpoints directly from within your Azure database (…) Read more
Posts Tagged ‘SQL’
SQL-query folding bug still alive and sucking in PowerBI and PowerQuery in Excel
Edit: There is currently no interest at Microsoft to change the current behaviour: http://community.powerbi.com/t5/Issues/Bug-Query-folding-not-working-with-non-SQL-datasource/idi-p/225100#M11611 . I found that this workaround works also pretty well (faster in most cases), as long (…) Read more