Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

visual not showing data due to error

this is the error 

(report uses DQ to PBI dataset)

 

"Couldn't load the data for this visual

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."

 

Activity ID: c9178d94-2e57-4270-8d13-c9a88a7db92e
Request ID: 7424bb74-63f4-8978-3363-65b49b3c4b06
Correlation ID: d1672fce-3864-40a3-037b-f2361e9ac851
Time: Thu Jul 22 2021 10:03:20 GMT+0200 (hora de verano de Europa central)
Service version: 13.0.16442.42
Client version: 2107.2.06866-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

Status: New
Comments
v-yingjl
Community Support

Hi @Anonymous ,

Please make sure you have configured the gateway correctly for your report in Power BI Service, refer this article:

DirectQuery for Power BI dataset: How does it work? 

 

In addition, when using Direct Query mode for Power BI datasets, here are the limitations that you could consider:

  • Parameters for database and server names are disabled. There are plans to support parameters in the future.
  • Defining RLS on tables from a remote source is not supported. There are no plans to support this in the future.
  • Using the following sources as a DirectQuery source is not supported:
    • SQL Server Analysis Services (SSAS). We plan to support SSAS Tabular models in the next major release of SQL Server. Support for SSAS Multidimensional models is not planned.
    • SAP HANA.
    • SAP Business Warehouse.
    • Real-time datasets.
  • Using DirectQuery on datasets that connect to SSAS using a live connection is not supported.
  • Using DirectQuery on datasets from “My workspace” is not supported. This will be resolved shortly after public preview.
  • Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets or Azure Analysis Services model is not yet supported.  We plan to support this as soon as possible.
  • Calculation groups on remote sources are not supported, with undefined query results.
  • For now, calculated tables are not supported in the Service when using this feature.
  • Sort by column is not supported at this time. This will be added soon.
  • APR (automatic page refresh) is only supported for some scenarios depending on the data source type. You can find more information in the APR documentation.

Refer: DirectQuery for Power BI datasets and Azure Analysis Services (preview) 

 

Best Regards,
Community Support Team _ Yingjie Li