Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I have had a rather critical OLE DB or ODBC error, which i have not been able to solve. When ever i try to open a KPI report i created i get the following error.
This applies to all former version and backups and prevents me from opening any file and changing the connection. It have tried to deleting the tables in datasets used, changing them to blanks, etc. but i all these cases i just receive the error below or the one above.
Thus i have been unable to acces the reports and change the connection since the direct query loads before the reports is opened. Meaning all the work building the report has been lost. Would it be possible to open the reports in some kind of safe mode or prevent PBI from loading the dataset before opening the report, such that i could remove the faulty connection.
Helper IDid you turn off the auto date/time feature in options and settings? In the source dataset? That localDateTable is from the auto date/time feature in options.
Did you try bringing it in again as a new source to see if it works?
Yes - tried to disable it both globally and in the source dataset. Unfortunately that did not work either.
Also tried to delete thet relevant table in the source database and create a simple one only with a blank column or a column with dates.
Ufortunately the error occurs when i try to open the file in the desktop. and prevents it from opening. So i cannot change the source inside the report.