Forum Discussion
Unable to read data from the transport connection:
Hi So aver the last two to three days I am having a varieity of issue with my Odata connection to CRM online. At first it was complaining with teh following error when trying to refresh the datas...
Hello guys, I recently encountered this error when I pulled data from Business Central and finally solved it so I want to share my solution for your reference.
I thought this error was caused by my data source at first. However, I was inspired by Jessica Wang's video https://www.youtube.com/watch?v=iVY1GkiYs-U and one reply in forum https://community.dynamics.com/forums/thread/details/?threadid=b6a8ffea-aaf1-4ece-a11e-1ecd8fa177ba
I converted the data type of whole numbers to text and then Power BI allows me to expand the merged tables, which is really simple and amazing. Hope this helps.