Forum Discussion
OLE DB or ODBC error.
Hi Steve_A ,
Please have a try.
- One possible solution is to check the credentials for the data sources you are trying to access. If the credentials are not set up correctly, it can cause errors when trying to access the data.
- You can also try refreshing the data sources to see if that resolves the issue.
I have also found a similar post, please refer to it to see if it helps you.
Solved: OLE DB or ODBC error: [DataSource.Error] - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response. I have already tried removing and re-entering credentials - it worked once but might just have been down to pure chance since it hasn't helped when trying that again (several times). I have also tried refreshing all the data sources but again not resolving the issue.
The solution in the thread linked was based on using lookupvalue instead of a merged table, not relevant to my situation but there are a few other suggestions in there that I will investigate further.
My current workaround has been to create a duplicate of the master table in each dataset being used and creating the DAX expressions there, then using relationships to link these tables to the master table. I can then use the grouping columns and filters from the master table in the visuals and bring in the columns/measures from the other datasets.