Forum Discussion

Girl_that_works's avatar
Girl_that_works
Regular Visitor
11 months ago
Solved

Sorry, error while retrieving data for this visual element

Hello, For several days, I’ve been encountering the following error on a visual in Power BI Service: “Sorry, we couldn’t retrieve the data for this visual. We couldn’t extract the data for this vis...
Need Help
  • Girl_that_works's avatar
    Girl_that_works
    11 months ago

    Hello Olufemi7 , 

    Thanks for the detailed answer. I tried this:

    Total Temps Boond = 
SUMX(
    FILTER('CRA Business One', ISNUMBER('CRA Business One'[Temps passé (J)])),
    'CRA Business One'[Temps passé (J)])

    And it did not work for me.

    I think the fact that I am using a composite model and that this column comes from a cloned table of a direct query table might play a role in this.

    For now, I just resorted to using the column itself in the report.

    Thanks for your help.

     

    Best regards.

  • Olufemi7's avatar
    Olufemi7
    11 months ago

    Hi Girl_that_works, 

    Thanks for sharing that!

    You're absolutely right composite models, especially when you're working with cloned tables from DirectQuery sources, can introduce some quirks in how DAX behaves.

    Functions like SUMX and FILTER don’t always evaluate as expected when the column comes from a DirectQuery path. 

    Using the column directly in the report sounds like a smart workaround for now.

    If you ever revisit the model setup, switching that table to Import mode or using a calculated table might give you more flexibility with your measures.


    Microsoft has a solid breakdown of how Import, DirectQuery, and Composite modes work in the Power BI Service definitely worth a look if you're digging deeper into model behavior.


    Power-BI/connect-data/service-dataset-modes-understand 

    https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models 

    Happy to help anytime if you want to explore other options or troubleshoot further!


    Best,

    Olufemi

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
11 months ago

Hi Girl_that_works ,
Thanks for reaching out to the Microsoft fabric community forum.

1) Check if the visual you are using is currently in preview stage because visuals which are in preview are only available for Power BI Desktop.
2) Be sure that you're using the latest version of Power BI Desktop. Go to one of these locations to download and install the latest version of Power BI Desktop:

3) Sign in to the Power BI service and try to upload the Power BI report from the target workspace by using the upload option.
4) Additionally as a final troubleshooting step try to clear out the cache and re check the visual functionality.
In Power BI Desktop, go to File > Options and settings > Options. Under GLOBAL, select Data Load, and then select Clear Cache.


I hope this information helps. Please do let us know if you have any further queries.
Thank you

  • Girl_that_works's avatar
    Girl_that_works
    Regular Visitor
    11 months ago

    Hello, I tried just that and to clear the cache and re-upload the report in the Power BI Service. 

    And unfortunately it did not work for me. 

    I just resorted to using the column itself in my report.