Forum Discussion
Dataflow - Desktop Connection error
I'm also having this problem, I'm not sure when it started, but everything seemed to be working last week.
The problem for me seems to be intermittent, sometimes it can connect and get the data, other times it can't even see the Dataflows. As far as I know, I have no problems accessing anything else, it just seems to be accessing Dataflows on Power BI Desktop. I have tried using Dataflows in different workspaces and still have this issue.
Sometimes I'm getting an OLE DB or ODBC error: [DataSource.Error] Unable to connect to the remote server. error message when I try to refresh the data in Power BI Desktop.
My Power BI Desktop version is 2.107.841.0 32-bit
EDIT: I just tested again with 2.118.621.0 64-bit (June, 2023) and I'm still running into this problem. I didn't think this would work, but it's always best to test with the newest version.
I'm also having this problem, I'm not sure when it started, but everything seemed to be working last week.
The problem for me seems to be intermittent, sometimes it can connect and get the data, other times it can't even see the Dataflows. As far as I know, I have no problems accessing anything else, it just seems to be accessing Dataflows on Power BI Desktop. I have tried using Dataflows in different workspaces and still have this issue.
Sometimes I'm getting an OLE DB or ODBC error: [DataSource.Error] Unable to connect to the remote server. error message when I try to refresh the data in Power BI Desktop.
My Power BI Desktop version is 2.107.841.0 32-bit
EDIT: I just tested again with 2.118.621.0 64-bit (June, 2023) and I'm still running into this problem. I didn't think this would work, but it's always best to test with the newest version.
Hello McGregor ,
Thanks a lot for your resposne and valuable time.
Last week i found the root casue of this error which was very trivial. I'm not sure about your scenario but in my case i had to create unique key columns which had combinations of both text and number so in some tables all the letters were in CAPS and in some tables those were in small. When changed everything to CAPS and tried loading the data it worked well and untill now no issues with the dataflow.
As my source was from Sql database where all these columns were by default in CAPS i thought it will be same while importing it, so didnt check this point and also i thought texts used in a dax inside " " where only case senstive but this one shocked me as i was revolving with issue for nearly a month.
