Forum Discussion

Bennykk's avatar
Bennykk
Frequent Visitor
3 years ago

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

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?
Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Bennykk
      Frequent Visitor
      3 years ago

      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