Power BI and BC OData Connector Failed
If you are getting this error message with the Power BI refresh in the service when refreshing a Power BI report that is connected to the BC data.
Here are the steps to resolve this issue.
- Download the Power BI semantic model and open it with Power BI Desktop. Choose Transform data.
- Right click on the table and choose Advanced Editor.
- If there are 4 “Null” parameter on the Source line then replace the 4th “Null” parameter with the following code.
- [UseReadOnlyReplica = null]
You will need to repeat this for all tables where there are four “Null” parameters on the Source line. If there are less then 4 or they do not contain parameters you need to do nothing.
Once you have updated all of the tables you can then republish your model to the service and attempt a refresh and it should be successful.