mysql

2 Topics

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
hello_
2 years ago Place DAX Commands and Tips
2.4KViews
0likes
4Comments
Connecting to Mysql as directQuery mode using Mariadb Connector
Hello, We have a requirement to monitor frequently updated data via Power bi and will be embedded in a web application, the data source is actually Mysql, Since MySQL Does not support DirectQuery Mode, I managed to connect to it via a MariaDB connector (which is usable to connect to Mysql Database), and the DirectQuery works perfectly fine with MySQL using this connector, I also managed to set up a gateway so it could connect to our locally hosted virtual machine that hosts the Mysql server, Everything seems to work fine. My question is, is this approach reliable enough to go to production? Should I expect any "weird" behavior, for example, if the data grows? I appreciate your help.
Solved
Anonymous
3 years ago Place DAX Commands and Tips
2.7KViews
0likes
1Comment