Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Giu
Frequent Visitor

Schedule refresh failed with Table.Combine

Hi all,

I have created a new table using the function =Table.Combine({BI_fact_aaa_deals, BI_fact_bbb})

The 2 tables are from the same datasource and they have the same fields.

I don't want to do a union all in sql statment beacouse the original views are used also for other direct queries

If I remove the refresh flag on power query table properties it works correctly but data into reports are not updates

Can you help me,please?

Thanks

1 ACCEPTED SOLUTION
johnbasha33
Solution Sage
Solution Sage

@Giu 

It sounds like you've combined two tables using Power Query in Power BI but are encountering issues with data not updating in reports when you remove the refresh flag on the table properties.

Here are a few steps you can take to troubleshoot and resolve the issue:

  1. Check Data Source Refresh Settings: Ensure that the data source settings are configured correctly to refresh data from the underlying data source. You can do this by going to "File" > "Options and settings" > "Data source settings" in Power BI Desktop.

  2. Verify Data Refresh Schedules: Make sure that data refresh schedules are set up correctly in Power BI Service (if you're publishing the report to Power BI Service). Check the dataset settings and schedule refresh to ensure that it's scheduled to refresh at the desired frequency.

  3. Review Query Dependencies: Double-check the query dependencies in Power Query Editor to ensure that all necessary queries are set to refresh. If you're combining tables using a function like Table.Combine, ensure that the underlying queries for both tables are set to refresh.

  4. Check for Errors During Refresh: Monitor the data refresh process for any errors or warnings. If there are errors, investigate and address them accordingly. You can view refresh history and error details in Power BI Service.

  5. Verify Data Model Relationships: Ensure that relationships between tables in the data model are configured correctly. Incorrect or missing relationships can lead to data not updating properly in reports.

  6. Test Data Refresh Manually: Try manually triggering a data refresh in Power BI Desktop or Power BI Service to see if the data updates correctly. This can help identify any issues with the refresh process.

  7. Consider Data Gateway Configuration: If your data source is located on-premises, make sure that the data gateway is configured correctly and running. Data gateways are required for refreshing data from on-premises data sources in Power BI Service.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

View solution in original post

1 REPLY 1
johnbasha33
Solution Sage
Solution Sage

@Giu 

It sounds like you've combined two tables using Power Query in Power BI but are encountering issues with data not updating in reports when you remove the refresh flag on the table properties.

Here are a few steps you can take to troubleshoot and resolve the issue:

  1. Check Data Source Refresh Settings: Ensure that the data source settings are configured correctly to refresh data from the underlying data source. You can do this by going to "File" > "Options and settings" > "Data source settings" in Power BI Desktop.

  2. Verify Data Refresh Schedules: Make sure that data refresh schedules are set up correctly in Power BI Service (if you're publishing the report to Power BI Service). Check the dataset settings and schedule refresh to ensure that it's scheduled to refresh at the desired frequency.

  3. Review Query Dependencies: Double-check the query dependencies in Power Query Editor to ensure that all necessary queries are set to refresh. If you're combining tables using a function like Table.Combine, ensure that the underlying queries for both tables are set to refresh.

  4. Check for Errors During Refresh: Monitor the data refresh process for any errors or warnings. If there are errors, investigate and address them accordingly. You can view refresh history and error details in Power BI Service.

  5. Verify Data Model Relationships: Ensure that relationships between tables in the data model are configured correctly. Incorrect or missing relationships can lead to data not updating properly in reports.

  6. Test Data Refresh Manually: Try manually triggering a data refresh in Power BI Desktop or Power BI Service to see if the data updates correctly. This can help identify any issues with the refresh process.

  7. Consider Data Gateway Configuration: If your data source is located on-premises, make sure that the data gateway is configured correctly and running. Data gateways are required for refreshing data from on-premises data sources in Power BI Service.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.