Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix not showing data after dataset refresh

Hi,   I'm new to the forum so I will do my best to describe my issue but I might forget some key info so don't hesitate to ask.   I created a report containing a matrix (see images "Before refres...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you Anonymous. It seems that I don't have the latest version installed. I will try this and let you know if it helps.

     

    Talk to you soon !

     

    David

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hey Anonymous, it turns out that my problem was not related to my power Bi version, though the latest version is way faster so thx for the hint ! 🙂

     

    Fortunately, I read the thread that you suggested and I found the answer in Wouter 's post (‎2017-10-18 06:57 AM) https://community.powerbi.com/t5/Issues/Visualization-BLANK-after-refreshing-page-in-Power-BI-service/idc-p/281447/highlight/true#M16169

     

    I was using Boolean in the filter for this particular visual and PowerBi service changed it into 0/-1 during the refresh. The solution => to convert the boolean into text in powerquery and to filter based on text.

     

    Thanks a lot for your help, and special thanks to Wouter 🙂

     

    Cheers !

     

    David

Nimai123's avatar
Nimai123
Post Patron
5 years ago

Hello Anonymous 

 

There may be an issue with the Date column as the Power BI service is not able to fetch it and Desktop is able to, you will get a clear and step by step explanation in the below blog, hope you replicate it and helps you.

 

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=2fe19f22-1ff8-4358-b464-540b0c3581de&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

 

IF YOU LIKE MY ANSWER PLEASE GIVE KUDOS AND IF MY ABOVE POST HELPS YOU TO SOLVE YOUR PROBLEM ACCEPT IT AS A SOLUTION. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Nimai123,

     

    Thanks for you response. I have looked at this post and compared my data from Bi Desktop and BI Online, but everithing is fine, the date formats are normal (there are some in text, but my date table has de date format yyyy-mm-dd). Also, I already know that the data is fine since I show the detailed rows into a table on another page. I guess that if there would be a problem with some dates, I'd have at least some numbers here and there in my matrix, but its completly empty.

     

    It has to be something else.. Anything else you think of ? 

     

    Thanks again.

     

    David

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous 

      Please check the version of your Desktop, if it is not the latest version, please upgrad it to the latest one.

      I found an issue: Visualization BLANK after refreshing page in Power BI service like yours, hope it could help you solve your problem.

       

      Best Regards,

      Rico Zhou

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank you Anonymous. It seems that I don't have the latest version installed. I will try this and let you know if it helps.

         

        Talk to you soon !

         

        David