ross27's avatar
ross27
Icon for Advocate II rankAdvocate II
3 years ago
Status:
Needs Info

All my DirectQuery connections to PBI datasets have stopped working

All visuals that use a direct query connection in published reports are now showing the error "Couldn't load the data for this visual"

 

In desktop, I can create a live connection to any of the datasets which works fine, but when I try to switch to direct query I get this error:

Any ideas?

Data Modeling
Reports

2 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ross27 ,

     

    For this error

    Are gateways configured for all local data sources involved? If it is successfully configured, please check for errors in "settings".

     

    Best regards,

    Community Support Team Selina zhu

  • ross27's avatar
    ross27
    Icon for Advocate II rankAdvocate II
    3 years ago

    Resolved this in the end.  My admin had been tidying up which security groups had XMLA endpoints enabled and had got a bit carried away!

     

Completed Ideas