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 !

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi Saraneh It might be due to inconsistent refresh mechanisms in Power BI Service. Ensure the table query doesn’t reference multiple sources without combining steps properly. Try setting UseStorageApi to true, as its default behavior supports most storage scenarios unless you're using the REST API explicitly. Confirm consistent credentials and permissions for the affected table in all environments.

Saraneh's avatar
Saraneh
New Member
1 year ago

Hi Akash_Varuna , thank you for your reply. 
I confirm that there's only 1 source, and cosistent credentials and permissions for that table. 
I tried to turn UseStorageApi to True, it didn't work either. 

 

I'm open to further ideas!