Couldn't load the data for this visual for PowerBI Service using direct query PowerBI database

[Bennykk]

Dear All,

In my report, I imported the data by 2 ways:

Import and Direct Query (PowerBI Dataset)

For import, visuals work fine.

For direct query, visuals work well in powerBI Desktop, but cannot be shown after publishing to Service

Activity ID: 49679c78-346b-455c-834b-11c3712648ac
Request ID: 3633f7fd-cbb7-45da-8cc1-0cfce2a294fd
Correlation ID: 7b510256-31ab-b7b2-3409-9144fc767583
Time: Wed Sep 28 2022 17:37:26 GMT+0800 (Hong Kong Standard Time)
Service version: 13.0.19134.41
Client version: 2209.3.13354-train
Cluster URI: https://wabi-east-asia-a-primary-redirect.analysis.windows.net/

Could you please help on this?

[ibarrau]

Hi. There might be a few reasons for this. One can be because you are adding columns/measures that can't be together on the same visual due to your data model. Another can be if you have publish the report and you haven't configure the credentials or gateway for the direct query. Then the queries can't reach the source to render.

I hope one of those helps,

[Bennykk]

Thank you. After further checking, it seems that is because of the connection issue. 
I use direct query to connect to PowerBI Dataset in orginational workspace which I have access and can see the report but not the dataset.

In powerBI Service, it shows there is no available gateway. 

I checked settings--> manage gateway --> it shows below

Thank you for all help