Forum Discussion
sam245gonsalves
Helper I
Helper IOLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][Hardy] (80)
I am connecting to a database in Databrick & creating a bar chart. I am counting accountid's by year(table A). However when I change to count(distinct) & use a filter from (Table B) accountid (Table...
I changed the accountid data type in table A to decimal & the chart seems to have rendered correctly.
accountid in table B is still whole number.
So weird...
hi Surabhi_p22, I am running into a similar issue. I can query the db directly, but getting error in PBI Desktop/PBI Service. Were you able to resolve your issue...if yes, can you share your learnings? Thanks, Jhyaikuti
Hi, Yes, my issue was resolved as we are connected to azure databricks for our source, the refreshes were failing because there was not enough memory in cluster, azure admin had to increase the memory and had to restart the cluster after that tables started refreshing at power bi end as well