Native query for Amazon Redshift - not working in the Service
I also confirmed we have the exact same issue with a .pbix in Import mode. We get that same error when we try to refresh it from the Service (though it works fine in Desktop).
I tested publishing to My Workspace per Anonymous, and other workspaces not in Premium Capacity. This does not make a difference; I still get the same error like "Native queries aren't supported by this value."
v-chuncz-msft / Microsoft, can you please investigate further / explain what is going on?
Now that I look at the blog again, it does say, the release of the features in this section may be delayed in some regions. We are working hard to ensure they are available in all public regions as soon as possible. Is that all it is? We just need to wait some more days or weeks? Any ETA? 🙃