getting following error while loading Views from sql server to power BI

[dd96]

I am getting following error while loading a View from sql server to power BI. 

I have premium license so storage should not be a problem. would be great if someone can help me to understand this error. 

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Invalid length parameter passed to the LEFT or SUBSTRING function.. '."

[dd96]

I would like to mentoin that the issue is resolved. 

Thank you 

[AVGUser_PBI]

HI, How did you solve this issue? I am getting the same error.

[v-yueyunzh-msft]

Hi , @dd96 

Glad that you solved the problem, if convenient, can you share the following causes and solutions that cause the problem?

Thank you for your understanding and support of Power BI.

Best Regards,

Aniya Zhang

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

[dd96]

Thanks for the reply but there is no pbix file genered as when trying to load sql view via import this the first error i get. 

[v-yueyunzh-msft]

Hi , @dd96 

According to the error message you provide: "Invalid length parameter passed to the LEFT or SUBSTRING function.", It can be seen that the sql statement syntax error is reported when querying the data.

For this kind of problem, you can download the .pbix file and go to the Power Query Editor to see if there is an error message for a step, or see if the SUBSTRING, LEFT and RIGHT functions are causing the error in Power BI Desktop.

For more information , you can refer to :

[Solved] invalid length parameter passed to the left or substring function in sql server - CodeProje...

SQL Server Helper (sql-server-helper.com)

Best Regards,

Aniya Zhang

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