Forum Discussion

Saraneh's avatar
Saraneh
New Member
1 year ago
Solved

HELP ! Table does not refresh on Services but does on Desktop

Hello everyone,  I have a weird issue where a table in my report doesn't refresh in PBI Services. It does refresh on desktop, the source parameter in power query "UseStorageApi" is set to false. Th...
Need Help
  • Saraneh's avatar
    Saraneh
    1 year ago

    Hello everyone, 

    Turns out my issue was simpler than expected, the 'Include in report refresh' option was unchecked on that table.
    We had just switched the dashboard to PBIP and published it for the first time in that format, which misled me into thinking it was a bug related to the file format or the deployment pipelines.
    Lesson learned: Always double-check the basics before jumping to complex explanations.
    Thank you all for the help !

v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi Saraneh ,

Sometimes residual metadata or broken lineage tags in the Service-side dataset block correct table updates, and only a full reset clears it.

 

Export your current PBIX

Delete the dataset in Prod manually once

Re-publish through the deployment pipeline (Dev > UAT > Prod)

Best Regards,
Chaithra E.

  • Saraneh's avatar
    Saraneh
    New Member
    1 year ago

    Hi v-echaithra ,

    Thank you for the help, I tried your solution in many ways 🙂 :

    - deleted the dataset and report manually in Prod and UAT and redeployed --> didn't work, tables not refreshed manually or automatically 

    - deleted the dataset and report manually in Prod and published directly in Prod to work around the pipelines--> didn't work either

    - published the dataset and report with a new name and in pbix format. Then deployed with the pbi pipelines --> didn't work either.

     

    I'm out of ideas and don't know how to move forward.