Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
webportal
Impactful Individual
Impactful Individual

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error

Hi,

 

This is my Dataverse table:

webportal_0-1700432433238.png

 

I simply want to import it to Power BI Desktop.

 

No transformations.

 

I go to Power Query, select the table, load it into Power BI Desktop and get the error:

webportal_1-1700432492560.png

 

1 REPLY 1
Anonymous
Not applicable

Hi @webportal ,

Please try:
Go to the File tab on the ribbon in Power BI Desktop, then click on About and check the Power BI version. Make sure it is the latest version. If not, update Power BI Desktop.
Download Power BI Desktop from Official Microsoft Download Center
If Power BI version is the latest, click on the dropdown arrow below the Transform Data button. --> Click on Data source settings. --> Click on Global Permissions. --> Select the Data Source and click on Clear Permissions and click on close. --> Click on close and again select the data source as new and enter the credentials.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors