Forum Discussion

dd96's avatar
dd96
Frequent Visitor
3 years ago

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

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 er...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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 - CodeProject

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