Error while loading power bi file in desktop

[Anonymous]

Hi All,

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

Any help would be aapreciated.

Thanks,

Swati

[Anonymous]

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]

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]

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.

[Anonymous]

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.

[amitchandak]

@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