Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Direct Query visuals not showing on powerbi service

I am creating pbi report using direct query with my local db (MSSQL) 

it is working perfectly on powerbi desktop but when i publish it on powerbi service the slicer (list) and text are showing correctly but visual are not showing .. error screenshot is given below.
dateset is connected using on-premises gateway

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    The issue is resolved i was using windows authentication before thats why it showing the error

    i have created a new user in sql and connect dataset using that user then it works..
    thanks for your reply!

2 Replies

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

    To give you better suggestions, could you please provide your steps?

    I suggest that you can try the followings:

    1, Check that if the gateway is properly connected and can be used normally.

    2, Try checking the memory, as not having enough memory will cause the visuals in the report to not display properly.

    3, Try to swap for another visual to see whether it can be shown up.

     

    Please refer to the following documents.

    Tips and tricks for creating reports in Power BI - Power BI | Microsoft Docs

     

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      The issue is resolved i was using windows authentication before thats why it showing the error

      i have created a new user in sql and connect dataset using that user then it works..
      thanks for your reply!