Can't Display the Visual (DirectQuery)

[Marios]

Hallo, 

I have created a connection to the cubes (with DirectQuery):

1. Gateway Settings shows that is online: You are good to go
2. Data Source Settings shows Connection successful
3. The measures and dimensions appears under the filters (as normal)

BUT when I try to create a report (I have try almost all visualizations) with measures or dimensions, the report created but indicates that ''Can't Display the visual. See details”. Also add the top of the page there is a warning “There was a data source access error. Please contact the gateway administrator. 

Any suggestions?

Thanks

[marksaba]

Was this resolved? I am facing the same issue and cannot change the gateway connection.

My report consists of a SharePoint and DirectQuery connection:

I can see all the visualizations just fine in Power BI Desktop but when I publish, I cannot see the Matrix which has fields from SharePoint and the Direct Query. When published, I can see a table with just SharePoint file fields and another with just DirectQuery fields. The issue only persists when they are in a visual together.

Please help

[malkalbani]

I am facing the exact same issue. The direct query display the visual in the desktop version but when published it gives this error (can't diplay visual). All data sources and connection seem to be good. Any idea what might have caused this?

[aj1973]

Hi @malkalbani 

What visual is it? can you send a screenshot from Desktop and from the service!

[malkalbani]

Hi, 

Solved. I had to modify the data gateway to link the sharepoint data source. I have data model that utilizes sharepoint and two SQL server connecitons. 

[malkalbani]

Here is error details

Activity ID: f1c4469e-62aa-4e85-94f0-1389ae899655
Request ID: bf7b5c81-d2cf-c72a-4df5-972900312d95
Correlation ID: 64d83162-2078-7bc2-4efe-c081b1a80c07
Time: Tue Jan 31 2023 13:06:35 GMT-0500 (Eastern Standard Time)
Service version: 13.0.19958.49
Client version: 2301.4.12022-train
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/

[v-huizhn-msft]

Hi @Marios,

Have you resolved your issue? Please refer to the information @Seth_C_Bauer posted, and share more details for further analysis.

Best Regards,
Angelia

[Seth_C_Bauer]

@Marios "Cubes" - I assume you are connecting to a SSAS multi-dimensional instance? Is it with all your data, or just certain elements? Asking because there are certain un-supported features like Calculated Members etc... Reference here

[Marios]

Yes with the term cubes i mean SSAS.When i create the reports using power BI desktop i dont have this issue but when i publish them the issues appears.

[v-huizhn-msft]

Hi @Marios，

It's weird, I test it in my local computer, all things works fine. Please check if you sign in the data gateway and power BI service using the same account? And update the gateway to latest version.

Best Regards,
Angelia

[Marios]

The problem still exists. I removed the gateway, reinstall it but nothing changes. Both measures and dimension appears in the fields panel, Gateway Settings “Online: you are good to go.”, Data Source Settings “Connection Successful” BUT “Can’t display the visual. See details” and “There was a data source access error. Please contact the gateway administrator”

[v-huizhn-msft]

Hi @Marios,

Please open a support ticket on the bottom of this page to check your own data background since we have no power to check customer's data.

Best Regards,
Angelia