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

[webportal]

Hi,

This is my Dataverse table:

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:

[Anonymous]

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