Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Viewing Direct Query Reports in PowerBI Service

Hi there,

 

I have a dataset that is linked to a SQL server via DirectQuery. I have developed some visuals for this data, and have been able to publish and access the dataset in PowerBI Service through an enterprise gateway. I have an automatic data refresh set up that seems to be working fine, and if I download the dataset as a .pbix file to open in PowerBI Desktop, the data is updated and the visuals are presented. The only problem is that I cannot view these visuals or even data fields in PowerBI service. Since the dataset is updating appropriately, I don't think it is a credentials issue. Any help?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have also cleared cache and removed all filters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous  ,

     

    It may be that the gateway version is too low and the visuals cannot be displayed

    If you are an administrator, you should see "Download Cloud" in the gateway section of Power BI Service. This indicates that you need to upgrade.

     

    Best Regards,

    Liu Yang

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