Forum Discussion
azaterol
Helper V
Helper VPowerBI Desktop and PowerBI Service and Database
Hello everyone, I've got a question. When I wrote inefficient code and built an inefficient database structure. This means tables are copied and pasted multiple times. How much does that affect per...
azaterol , In the import mode data is first stored in pbix, and then once you published it stores on azure cloud.
Refresh on service can add data in service, independent of the desktop
In direct query mode, Power bi do not store data, only store meta and cache results for performace
v-jingzhang
Community Support
Community SupportHi azaterol
When tables are copied and pasted multiple times in the model, the model size will be enlarged. When you use a report in Power BI Desktop, the whole data model of the report is held in the memory of your computer. And too many complex formulas will consume more memory and CPU resources for calculation than efficient formulas. All these will make the report perform slower.
Best Regards,
Community Support Team _ Jing