server error

2 Topics

Odata - failed to connect to data source - Remote server returned an error : (400)
Hi, Trying to connect Clarity PPM data warehouse using Odata but get this error message: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (400) Bad Request. ([HYT00][0] Login has timed out.). '. The weird things is that I am able to conncet to a different environment with no issues. Please advise how to solve this, Dovi
Dovi
3 years ago Place Report Server
2.3KViews
0likes
3Comments
We cannot convert the value "[Table]" to type Table.
Hi, I donot face any error in Power BI Desktop. but while running same report on server, I face below error. Waiting for support. We cannot convert the value "[Table]" to type Table. Here is the M query. let Source = Folder.Files("\\IPACK-SVR-FILE\Production\10-Waste\Employee of the Month"), RemoveOtherColumns = Table.SelectColumns(Source,{"Content", "Name"}), SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000), ListInput = Table.ToRows(RemoveOtherColumns), ConvertOneFile = (InputRow as list) => let BinaryIn = InputRow{0}, FileName = InputRow{1}, BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64), SplitUpText = SplitTextFunction(BinaryText), AddFileName = List.Transform(SplitUpText, each {FileName,_}) in AddFileName, ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)), CombineLists = List.Combine(ConvertAllFiles), ToTable = #table(type table[Name=text,Pic=text],CombineLists), AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1), #"Filtered Rows" = Table.SelectRows(AddIndexColumn, each ([Name] <> "Thumbs.db")), #"Split Column by Delimiter" = Table.SplitColumn(#"Filtered Rows", "Name", Splitter.SplitTextByDelimiter(".", QuoteStyle.Csv), {"Name.1", "Name.2"}), #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Name.1", type text}, {"Name.2", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Name.2"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Name.1", "Name"}}) in #"Renamed Columns"
Solved
MI
4 years ago Place Report Server
2.7KViews
0likes
7Comments