Forum Discussion

fyrworx's avatar
fyrworx
Frequent Visitor
10 years ago
Solved

Data Loading Times

Hi   Being new to Power Bi, I am looking into some of the best pratices and have a few questions on load times and data sizes.   When reading in data, has anyone come across any data size limitat...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    10 years ago

    Hi fyrworx

     

    Yes, PowerBI provide trace log files for users to analyse Power BI Desktop execution performance. First you need to collect some diagnostics by enabling tracing on Power BI Desktop, go to: File –> Options –> Diagnostics –> Enable Tracing.

    Reference: Power BI Desktop Trace Logs Analyser

     

    Because it is not very easy to read the log file opened in notepad, you can create a Power BI Desktop to process and visualize the trace logs.

    Reference: Power BI Diagnostics, Trace Logs And Query Execution Times

     

    Best regards,
    Yuliana Gu 

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

fyrworx

 

1. PBIX file size limit is 1GB and check out here data limits in powerbi.com based on level of subscription.

2. Largest size of dataset I've imported within power bi data model is approx 1-2 GB. Any data size more than that I would prefer to use DirectQuery feature.

3. If you've got schedule refresh setup then in power bi service you can go to settings icon on the top right hand corner -> Settings -> Datasets -> Refresh history