Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error while loading power bi file in desktop

Hi All,

 

I am getting above error while opening pbix file i PBI desktop.

Any help would be aapreciated.

 

Thanks,

Swati

5 Replies

  • Anonymous , what was the file type? Can you copy the error and share it?

     

    Open Power Query and check do you see any detailed error

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Please make sure your Power Desktop version is the latest version.

     

    There is a 1 GB limit per dataset that is imported into Power BI. 

     

    For larger data, you can choose Direct Query/Live connection connection mode, or optimize and delete the original data.

     

    Best Regards,

    Stephen Tao

     

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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao

    • Anonymous's avatar
      Anonymous
      Not applicable

      I am not able to change existing connection from import to direct query in data source settings, as i am not able to see above screen. I can see below screenshot where there is no option like above screenshot .

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous ,

         

        You need to clear the existing permission before you try to change your connection mode.

         

         

        Best Regards,

        Stephen Tao

         

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