Forum Discussion
Dataset size not updated when republishing report
- 1 year ago
Hi SamVH12 ,
When you use DirectQuery, Power BI doesn’t actually store the data—it just connects to the source and pulls what it needs on the fly. But if there’s an old dataset still sitting in the workspace from when the report was using Import mode, that could explain the size mismatch.
Now, when you rename and republish the report, Power BI sees it as a fresh upload and creates a new dataset that matches the current setup, which is why the size looks right in that version.
Just double-check that your dataset in the workspace is actually running in DirectQuery mode so everything lines up properly
can you refer below doc : https://spgeeks.devoworx.com/switch-import-to-directquery-mode-powerbi/
Hope this helps !
If this post helps ,please consider marking Accept as solution to assist other members in finding more easily.
check again in a couple days. These statistics are not updated in real time.
- SamVH121 year ago
Helper I
lbendlin It has been 3 days, and so far, it has not been updated. Would you be able to share how often updates occur?
- lbendlin1 year ago
Super User
I think you'll want to raise a ticket. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . - v-aatheeque1 year ago
Community Support
Hi SamVH12 ,
When you use DirectQuery, Power BI doesn’t actually store the data—it just connects to the source and pulls what it needs on the fly. But if there’s an old dataset still sitting in the workspace from when the report was using Import mode, that could explain the size mismatch.
Now, when you rename and republish the report, Power BI sees it as a fresh upload and creates a new dataset that matches the current setup, which is why the size looks right in that version.
Just double-check that your dataset in the workspace is actually running in DirectQuery mode so everything lines up properly
can you refer below doc : https://spgeeks.devoworx.com/switch-import-to-directquery-mode-powerbi/
Hope this helps !
If this post helps ,please consider marking Accept as solution to assist other members in finding more easily.- v-aatheeque1 year ago
Community Support
Hi SamVH12
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!