Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Wondering if anyone could confirm my thoughts on this one: I'm using Desktop to connect to an Azure SQL Database through Import Mode so I:
1) Connect to the DB
2) Choose the tables or views I that contain the data for the report
3) Reduce the columns down to just what I need for the report.
Up till then all good, but then, for example, if I want to calculate Age from DateOfBirth column, using the Date>Age function under the Transform tab, it communicates back to the DB for some reason and takes about 5 minutes to do.. what? I though that the whole point was that you import the date and then manipulate it in-memory but by the looks of things this isn't the case. I could understand that once you've finished in Query Editor and you 'Close & Apply' it might need to update the date...
Why does PBI go back to the DB in this case?
Any thoughts would be appreciated!
Matt
Solved! Go to Solution.
Hi @Matt_Alexander,
Based on my understanding, each time when a transformation, or step, is applied to the data in Query Editor, the corresponding M query will be executed against the DB. You can view the applied steps under the Applied Steps section of the Query Settings pane.
If you want all the steps to be applied only when you click 'Close & Apply' instead of applying every steps during manipulation in Query Editor, you can write all the transformations using the M Language (which is how Query Editor records steps in the background), using Query Editor’s Advanced Editor.
Regards
Hi @Matt_Alexander,
Based on my understanding, each time when a transformation, or step, is applied to the data in Query Editor, the corresponding M query will be executed against the DB. You can view the applied steps under the Applied Steps section of the Query Settings pane.
If you want all the steps to be applied only when you click 'Close & Apply' instead of applying every steps during manipulation in Query Editor, you can write all the transformations using the M Language (which is how Query Editor records steps in the background), using Query Editor’s Advanced Editor.
Regards
OK thanks for the information @v-ljerr-msft
Shame it doesn't 'cache' the changes and then apply them when 'Close & Apply' is clicked!
Matt
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |