Dataset size not updated when republishing report

[SamVH12]

Hi guys,

I faced an issue that when I switch sources to Direct Query and republish the report to the workspace to replace the one using Import, which I have done before, the dataset size still has big storage, which is more than 90 MB (this size is of the old report).

However, I did a test to rename the report and publish it, and it is just only 2 MB, the same as I checked in the file properties on my desktop. So, I wonder somehow my report can't replace the size of the dataset in the workspace.

Does anyone know the reason?

I would appreciate it!

[lbendlin]

check again in a couple days. These statistics are not updated in real time.

[SamVH12]

@lbendlin It has been 3 days, and so far, it has not been updated. Would you be able to share how often updates occur?

[v-aatheeque]

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-aatheeque]

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!

[v-aatheeque]

Hi @SamVH12 

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[v-aatheeque]

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!

[lbendlin]

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 .