Table refresh by using external tolls

[jswamy]

How tor Refresh the table if the table was disabled on "Include Report Refresh " in power query and published in power bi service.. is there any external tools for refresh the table with enire data... As i know if "Include Report Refresh " is disabled the table data wont refresh in power bi service... but i wanted to try even its disbaled need to refresh entire data. Please let me know if there are any ways to check this POC.

[jswamy]

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,

[Anonymous]

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

[Poojara_D12 · Accepted solution]

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)

[Poojara_D12]

Hi @jswamy 

If the "Include in Report Refresh" option is disabled for a table in Power Query, it won’t refresh automatically in Power BI Service. To refresh such a table externally, you can use tools like Power Automate or REST APIs to push updated data into Power BI manually. Here's how:

1. Power Automate:

   • Use a scheduled flow to fetch data from your source and update the dataset in Power BI.
   • Use the "Refresh a dataset" action for triggering dataset refreshes.

2. Power BI REST API:

   • Use the POST Dataset - Refresh Dataset In Group API to programmatically refresh the dataset.

3. Direct Query/Live Connection:

   • Switch the table to Direct Query or Live Connection mode if applicable, so data updates on-demand.

You can script the process or integrate with your existing ETL workflows.

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