Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My report will no longer refresh and is returning this error:
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: The connection returned error code -2147467259..
I did not make any changes to the report, and it was refreshing without any issue before (i.e. last week).
Any help would be appreciated.
and did you solved this error? how?
I have the same error message
@huguest Are you able to connect to the same database through SSMS (SQL Server Management Studio).
Proud to be a PBI Community Champion
I am not an IT person, so I am not able to answer that question. I was able to preview the query in the Quety Editor, and refresh the preview, without any problem though.
Hi @huguest,
Do you have this error message when you click Refresh Button in Power BI Desktop?
Is your data source Sql Server Database?
Best Regards,
Cherry
Yes, I do have the error when I click on Refresh (not immediately, only after a while). I have several data sources but one of them is a sql database.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |