Refresh error

[Anonymous]

Is there a difference between using SQL view or Tabular cube as a source data to speed up refresh time in Power BI?
Is there also any other solutions for speeding up Power BI refresh time when using many rows?

Sometimes I get an error that says Not Enough Memory To Complete This Operation.
Regards,

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

"Is there a difference between using SQL view or Tabular cube as a source data to speed up refresh time in Power BI?"

No, unless you change the storage mode (connection mode), such as using Direct Query or Live Connection.

Manage storage mode in Power BI Desktop 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer thee two

https://community.powerbi.com/t5/Desktop/POWER-BI-AND-SSAS-Tabular-or-MULTIDIMENSIONAL/m-p/183269

https://www.ptr.co.uk/blog/should-i-build-tabular-model-or-olap-cube

[amitchandak]

@Anonymous , For memory error

https://social.msdn.microsoft.com/Forums/en-US/a35eb4e5-3768-41f5-b50d-98a87e003806/tabular-model-powerbi-theres-not-enough-memory-to-complete-this-operation?forum=sqlanalysisservices

https://blog.magnetismsolutions.com/blog/colinmaitland/2019/02/05/power-bi-desktop-memory-issue-resolution---part-1

https://www.reddit.com/r/PowerBI/comments/gqkeq1/memory_error_how_to_deal_with_it/

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=6cd37af6-e634-4497-afb8-20e7e9ddaf26&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer