Visuals not displaying at the tenant

[Anonymous]

Hi guys, can I pick up your brain please. 

I have  a challenge with connection to Dynamics 365 (direct query for OptionSet table). 

When I connect and build report from home (in PowerBI App), it works with no issue. However when I publish it to the tenant, all visuals which includes driect query table have error.  All the rest is ok.

Error:

"Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details"

Also when I work from the office I can't connect to Dynamic 365 at all. However using same credential working from home I can conect in the PowerBi App. 

TIA

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

Power BI doesn't import data over connections that operate in DirectQuery mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. So if your data source can't connect to gateway, you will get the error message.

Please make sure Gateway works fine whether you are at home or at the office.  Maybe your gateway works fine when you are at home, but offline or not reachable when you are at the office. 

For more information, please refer to:Manage your data source - SQL - Power BI | Microsoft Learn

Best regards,

Yadong Fang

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

[Anonymous]

Thank you for coming back to me.

Apologise if it is quite obivious, but will  it also work for CRM Dynamics 365 cloud base? 

TA