Forum Discussion

HarmVanG's avatar
HarmVanG
Icon for Advocate IV rankAdvocate IV
9 years ago

Reports get disconnected from Dataset

Hi guys,

 

I'm currently creating reports based on only Salesforce objects. When I publish them to the service it works great, however after some time, my reports get 'disconnected' from the dataset.

When I look in the report it shows that the rows are empty.

 

When I look in the dataset however, they are present.

 

This occasionally happens after some time. I've schedueled a daily refresh but I don't get any error emails.

 

Does anybody know what's going on? :smileyfrustrated:

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    HarmVanG

     

    Did you try to "Refresh" in report?

     

    Can you create a brand new report with this dataset to see if it can display data properly?

     

    Regards,

    • HarmVanG's avatar
      HarmVanG
      Icon for Advocate IV rankAdvocate IV

      Hello Simon,

       

      Yes I tried that, the only way for me to fix it is by republishing the .pbix file.

      I can create new reports on that dataset that shows the data properly.

       

      with kind regards,

       

      Harm