Has anyone ever seen the below error message when attempting to refresh data in a Power BI report. This looks like a SQL error message, but I am not really finding anything online that helps me resolving it. We are connecting to Business Central utilizing OData.
Have you tried to connect Power Bi Desktop and go to the data transformation to see if there is an error on the refresh for that dataset? I would test this and another area to look at would be in the data credentials in the Power Bi service. If you choose the … on the dataset you can get into the security and then data source credentials you can see if you are getting an error there just like the screenshot. Here is where you can correct the credentials.
If you need more assistance I am happy to help.