Thanks @paulag for giving visibility to the importance of the NOLOCK sql hint.
Yes, I implemented a workaround with views and the the use of the NOLOCK can be omitted. For those who missed the post, you can read it here. One still need to be aware that they will get dirty read with the NOLOCK and the result set might not be consistent.
Anyway, good to know how it works and how to use it with Power BI. It will be very useful for people using Power BI and other databases.
BTW, SELECT * FROM TxTransfers (NOLOCK) might not be the best example to show, as this unfiltered query returns more than 3 millions rows :/
"BTW, SELECT * FROM TxTransfers (NOLOCK) might not be the best example to show, as this unfiltered query returns more than 3 millions rows :/"
I did not consider this, very valid point
Thanks for adding the link back to your post. This tutorial is not only aimed at those using steemsql but also those connecting to any live sql database. I will be sending out a link later on in a newsletter to a power bi community as it is a relevant topic to cover