SQL Syntax Error in Power Bi while fetching Data From Diff Tables to Table - Visual
Hello Authors Please land me some help, I am getting Data from mysql server (Version 8.0) by MariaDB connector (in Direct Query) the schema is Star there and has 3 Tables and 2 connection between tables. Connection - FactTable - table2 (Many to many) FactTable - table3 (Many to One) when I try to put or see data in Table Visual I face this error when I put - Field1 from Table3 Field2 from FactTable What Should I do please Guied Thank You in Advance
MdxScript(Model) (9, 47) Failed to resolve name 'SYNTAXERROR'
Hello I have next error message when I save the report on Power BI Report Server (January 2019): "Не удалось загрузить данные для этого визуального элемента MdxScript(Model) (9, 47) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name. Повторите попытку позже или обратитесь в службу поддержки, указав следующие сведения. Идентификатор запроса: b129dfd4-a86e-b164-f773-590426b1ead8 Время: Thu Dec 19 2019 15:26:15 GMT+0300 (RTZ 2 (зима)) Версия: 15.0.1102.235" Report works OK on Desktop. I didn't found any information about this error. Please, help.
