Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Bi Scheduled Refresh Time Out

Hi guys, I am new to Power Bi and require some help on it. I have created a new Power Bi file where it is reading excel files from SharePoint. The dashboard has been published to web using my PowerBi...
power bi schedule error refresh not working
PowerBI Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    You can reduce the file size from the following ideas:

    Optimize the data model,relationship,dax formula.

    Reduce the data source data, clean unused data regularly.

    Only import the columns you need.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Do you know which part of your process causes the long duration?  In Power Query you can do query performance diagnostics to see which part takes the longest.

How big are your Excel files?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes, i think i know which part of the process causing the long duration, it will be due to pivot and unpivot of data to do some calculation. 

 

I have about 1 file of 80 MB which uses the process above and about 20 files of 60MB which is just direct read of from SharePoint