invalid number in sql view but not in table

[Anonymous]

Dear all,

I am importing sql views from oracle database to power bi. I have recently added a new column to my view and when I want to refresh my data in Power BI, it says "invalid data" in my view. 

The same error is shown when I want to import the view from new on. 

I have created a respective table with the same query as for the view in sql and it doesn't show an error message when importing it to Power BI. I don't want to accept using a table as a solution, however, but rather find the actual error.

Do you have any idea what the reason could be or where to look for the error?

Thanks,

Susanne 

[v-xuding-msft]

Hi @Anonymous ,

It might be caused that the data type is not same as your data source. Power Bi will change type automatically after connecting data source. So I think maybe it causes the error. 

Please check the data type of the column and change it to same as the data source. Then refresh the data model.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[Anonymous]

Dear XUE 

I get the following error message:

DataSource.Error: Oracle: ORA-01722: Ungültige Zahl (invalid number)
Details:
DataSourceKind=Oracle
DataSourcePath=orafacultdev
Message=ORA-01722: Ungültige Zahl
ErrorCode=-2147467259

How can I change the data type? Since I get the error message, I cannot apply any steps in the power query editor 

Kind regards,

Susanne

[Anonymous]

cast as varchar in query and after importing convert to the whole number. I don't know but power bi assumes that conversion is not happening at run-time. Power BI should update this kind of metadata adjustment while sourcing the data. 

[Anonymous]

Thanks sppskuldeep, this really helped me alot.