Forum Discussion
Table refresh by using external tolls
Hi jswamy
Yes, the reason you're not getting the full data is because the "Include in Report Refresh" option is disabled for that table. When this option is disabled, the table does not refresh its data during any refresh operations, including those triggered via Power Automate or the Power BI REST API.
To get the full data, you must enable "Include in Report Refresh" for the table. There’s no other workaround to refresh that specific table unless you re-enable this setting.
If enabling this is not feasible for some reason, your only alternative is to manually update the data source for that table or load the data into a separate dataset that is refreshed independently. However, this approach adds complexity.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS (360 remaining for 500 SUBS)
Hi Poojara,
Thanks for the response, As you mentioned, I tried with Power Automate and Power BI Rest API , the refresh part is working good but, I am not getting the full data from that table( is this because of "Include in Report Refresh" option is disabled?). While publishing the report, the rows count was 100 and after refreshing from Power Automate and PBI REST API's the rows count remains same... Do we need to enable "Include in Report Refresh"? or is there any other way to get the full data without enable the "Include in Report Refresh". Please let me know.
Thanks,
Hi jswamy
Yes, the reason you're not getting the full data is because the "Include in Report Refresh" option is disabled for that table. When this option is disabled, the table does not refresh its data during any refresh operations, including those triggered via Power Automate or the Power BI REST API.
To get the full data, you must enable "Include in Report Refresh" for the table. There’s no other workaround to refresh that specific table unless you re-enable this setting.
If enabling this is not feasible for some reason, your only alternative is to manually update the data source for that table or load the data into a separate dataset that is refreshed independently. However, this approach adds complexity.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS (360 remaining for 500 SUBS)
Hi jswamy
Did Poojara_D12‘s method solve your problem? If yes, could you please mark it as solution? This will help more users facing the same or similar difficulties. Thanks!
Best Regards,
Yulia Xu