Forum Discussion

jswamy's avatar
jswamy
Regular Visitor
1 year ago
Solved

Table refresh by using external tolls

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.....
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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's avatar
Poojara_D12
Super User
1 year ago

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