Data Mozart Make Music from your Data!| data-mozart.com | @DataMozart | Microsoft Data Platform MVP | Power BI Addict | Blogger, speaker, learner, = Value.NativeQuery(Contoso,"SELECT * FROM FactOnlineSales",null,[EnableFolding=true]), = Value.NativeQuery(Contoso,"SELECT * FROM FactOnlineSales AS fco INNER JOIN DimCustomer AS c ON c.customerKey = fco.customerKey",null,[EnableFolding=true]). Note that you must use a work or school address to sign In the Query Properties dialog box, select the Definition tab. This statement should be correct, right? Inspiration came from this great blog post from Chris Webb, and Ive just slightly adjusted it in the following example: As you may notice, I will not write my SQL statement in the starting window. You can also revoke the approval of any native database queries that you've previously approved for a given data source in either Power BI Desktop or Excel. Change the T-SQL Script of a Power BI Table without Add - RADACAD Click on the query that you need to edit your SQL statement. In the dialog box left pane (colored green), select the credential type you want:NoteThe password is not encrypted when sent. and other issues with data sets in Power BI. To do so, click on the triangle on the left of the Fare column name and then click on the Number Filters property. The view will contain the whole transformation logic, and you can then import it as-it-is in Power BI. In this short article I show how this limitation can be overcome. Therefore, it is your responsibility as a user to decide whether it makes sense and is permissible to use the described workaround or not. to get a summary of my favourite Power BI feature releases in 2020. I would Kudos if my solution helped. Wenn Sie die Website weiter nutzen, stimmen Sie der Verwendung von Cookies zu. Well, not anymore:). The first step was to define the correct target, which in this case is the database where the SQL code will be run. of Power BI Desktop (PBID). Finally, lets check if this workaround had an impact on the data refreshing process: This time, by pushing the filter upstream to a SQL database, Power Query retrieved only those rows that we needed.