Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unable to Disable Refresh on Static Tables on Service

Hi,   I pasted excel content onto a Configuration Table (enter data in Power BI Desktop) unchecked Enable Load and Include in refresh option in Power BI Desktop.   I generated a list by referncin...
Need Help
Show and Tell
Tips and Tricks
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

 

To disable refresh for a table in Power BI, you can follow these steps:

  1. Open the Power BI Desktop file that contains the table you want to disable refresh for.

  2. Go to the Home tab and select Edit Queries.

  3. In the Queries pane, select the table you want to disable refresh for.

  4. In the Properties pane, locate the option for Enable Load and uncheck it.

  5. Repeat the same steps for any other tables you want to disable refresh for.

  6. Save and publish the report to Power BI Service.

After following these steps, the table should be disabled for refresh in Power BI Service. If you still see the table included for refresh after publishing to Power BI Service, you can try refreshing the report and checking again. If the issue persists, you can try deleting the table from the report and re-adding it with the Enable Load option unchecked.

 

Best Regards,

Community Support Team _Charlotte

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
3 years ago

v-zhangti

 

Yes. I do know the steps.

 

My question is .. after publishing the report (after following the above steps),

 

7. Download PBIX file from service ...

Open Advance editor ... and you will see that the static tables are now enabled for refresh!!! Hence I wanted to bring this to your attention.