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.
Hi,
I have a problem with Power Query and Power BI Desktop. One of my tables (MS SQL view connected via 'Import') does not refresh after modification. I modified one row (two of its columns), clicking 'refresh preview' in Power Query and 'refresh' in data view in PBI Desktop, it sais "connecting" and "... rows loaded', but data remained unrefreshed. After trying several times and clearing the cache (Options -> Data load -> Clear cache) and refreshing again, one of the column has been updated, but the second still has old value.
Duplicating the query does not help. But creating it from scratch (copying only the first step with database parameters, and selecting the table (view) from list) does get the fresh data.
What can I try to get fresh data without exchanging the query in data model ?
TIA,
Ryszard.
Solved! Go to Solution.
Hi @rylach,
Based on my test, it could work on my side, I suggest you to check the version of Power BI Desktop(2.61.5192.601 64-bit (August 2018)) and you could also try to uncheck below option: Files->options->current file->Data Load->Auto Date-time to improve the performence.
Also, please try to deselect “Allow data preview to download in the background” option.
Besides, you could also refer to this link:Speed up the PowerBI and Power Query design process
Regards,
Daniel He
Hi @rylach,
Based on my test, it could work on my side, I suggest you to check the version of Power BI Desktop(2.61.5192.601 64-bit (August 2018)) and you could also try to uncheck below option: Files->options->current file->Data Load->Auto Date-time to improve the performence.
Also, please try to deselect “Allow data preview to download in the background” option.
Besides, you could also refer to this link:Speed up the PowerBI and Power Query design process
Regards,
Daniel He
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |