error in tabular model refresh within Visual studio

64946565 1 Reputation point
2021-04-02T10:45:46.52+00:00

Hello, I hope you are doing well!

When I am trying to refresh a tabular data model within visual studio that is using a Oracle data source; I am getting the following error message :

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'

NB : the refresh is working when I deployed the model on a ssas tabular model instance( weird)

any idea please ?

Thnaks in advance

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-04-05T04:22:59.233+00:00

    Hi,

    What compatibility level tabular model are you dealing with ?

    Could you try switch the provider here in the project, see if other providers work. It is listed here : Supported data sources for in-memory tabular models


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.