User Profile
cl27274
Copper Contributor
Joined Feb 03, 2021
User Widgets
Recent Discussions
Excel Query not working on different computer
Hello, I have an excel workbook with a query. The workbook is in a folder on One Drive. I can run the query just fine from my computer. One of my co-workers can run the query just fine from their computer. But another co-worker can't run the query, it gives them an error: I tried deleting this transformation and the next transformation was also giving an error. I tried deleting that one as well and the next transformation also gave the same type of error. Not sure why this is happening. Thank you for the helpRe: Power Query - Expression.Error: Illegal characters in path, cell value as input
SergeiBaklan This is the code for GetValue() (rangeName) => Excel.CurrentWorkbook(){[Name=rangeName]}[Content]{0}[Column1] In a cell or in a table, I want to have text - that is the query I want to run. The value in the lookup table/cell is a concatenation of different cells that makes the text Odbc.Query(....). The reason for the concatenations is to be able to modify the query from another table. I want to run the query: Odbc.Query(.......). I have now tried putting the query into a table and referencing it with this fParameter function: let Parameter=(TableName,ParameterLabel) => let Source = Excel.CurrentWorkbook(){[Name=TableName]}[Content], value = Source{[Parameter=ParameterLabel]}[Value] in value in Parameter Instead of executing the query, it loads a 1 column, two row table that looks like this: I hope this clarifies it a little bit.A connection was successfully established with the server, but then an error occurred during the pre
@Sergei Baklan I'm trying to use parameters in power query. I am now having a new error appear: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Details: DataSourceKind=SQL DataSourcePath= (some server name) Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ErrorCode=-2146232060 Number=10054 Class=20 I'm connecting to a Linux server, OS: 3.16.0-4-amd64. Typically, when connecting to it I go to get Data -> Odbc -> and then select the DSN and paste my SQL statement in the advanced options ... and it works perfectly Now I'm trying to use the following M code and it is giving me the error shown above Source = Sql.Database(Server, Database,.....) Thank you for the help
