cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sharron
Regular Visitor

System running extremely slow

I'm new to Power Bi and using the desktop version with a Pro license. I had our data running off my local laptop but thought it was safer to have the data stored on the Google drive. I've remapped all the data sources to the Google drive but this has made the reports and any changes really slow. Is there any way I could speed things up in terms of performance. Our data isn't very big as we are a school.

1 ACCEPTED SOLUTION

@sharron , can be the reason, But I am not sure on that. there can be a limit also how much and what speed you can query.

 

So first we need to check if there an issue with the model and fix that.



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@sharron ,You can analyze performance using DAX studio. And fine tune the reason or share here

https://www.sqlbi.com/articles/importing-performance-analyzer-data-in-dax-studio/

 

Another thing if you can move it to one drive and try

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Thanks but we are a school running on Google and not Microsoft so we don't use One drive much.

@sharron , check if you get something on DAX analyzer share any specific issues.

Also can share data model diagram.

 

Also, refer

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

 

or

https://community.powerbi.com/t5/Service/Why-is-loading-refreshing-data-in-powerbi-cloud-or-same-pro...



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Does running it off Google drive slow it down?

@sharron , can be the reason, But I am not sure on that. there can be a limit also how much and what speed you can query.

 

So first we need to check if there an issue with the model and fix that.



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors