Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The setup is Sharepoint Online lists that are imported into a dataset. The refresh schedule on the service is 0000 0800 1000 1400 1600 1800 so six times per day.
When working on DAX querys and the data model a copy of the dataset is downloaded from the service as a pbix file.
Open the pbix dataset file in Power BI Desktop (PBID). PBID is set to 'Always allow data previews to download in the background' so as soon as I open up the dataset file in PBID the background refresh fires. All and good :}
First question; which refresh button would be the 'background refresh' equivalent, 'Refresh' on the designer side or Power Query Editor (PQE) > 'Refresh All' ?
Second question; after the auto 'background refresh' has completed, why does the last two tables (most recent) in PQE show the warning 'This preview may be up to <n> days old ?
If I fire the designer side refresh, this will appear to have no effect to the refresh status of these last two tables and show the same 'days old' warning.
Both these tables are SPO list sourced. Both tables have their settings of 'Enable load' and 'Include in report refresh' set.
There are currently 29 querys in all. All other tables have their settings of 'Enable load' and 'Include in report refresh' set.
The two tables in question are the lastly created tables of the 29 (and this should not make any difference but just stating the facts).
Obviously the current work around is to manually refresh the last two tables one at a time via 'Refresh Preview' and/or hit 'Refresh All'
Screenshots
Solved! Go to Solution.
Hi @garythomannCoGC
When launch PQE, it import data for preview and run PQ steps, but it depends on Data Source and data quantity. When PQE loaded, it may be refresh and import new data, some times it run out of times and new data is not import.
So we need to run the Refresh All or Refresh specific query to make sure all new data are loaded successfully.
I faced same type of issue, when table has less data, successfully loaded all data from Azure Datalake. Same time big dataset table fail to load the all new data.
Hope it helps you, please keep inform
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Interesting, thanks for your response PijushRoy, so the tables being at the end of the refresh line, so to speak, could be the reason this is occuring. But the tables are tiny and there are four other tables of same design (not me) as the first of the two in question.
Hi @garythomannCoGC
When launch PQE, it import data for preview and run PQ steps, but it depends on Data Source and data quantity. When PQE loaded, it may be refresh and import new data, some times it run out of times and new data is not import.
So we need to run the Refresh All or Refresh specific query to make sure all new data are loaded successfully.
I faced same type of issue, when table has less data, successfully loaded all data from Azure Datalake. Same time big dataset table fail to load the all new data.
Hope it helps you, please keep inform
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |