Forum Discussion
Solved
"Fatal error" when using MySQL variable in query
I am trying to create a visualization which shows the cumulative contributions to a portfolio over time and its market value at given dates. I'm connecting to a MySQL database. I initiate the co...
I’ve got response from the Product Team.
This is outside the control of Power BI. We rely on the MySQL ADO.NET driver to correctly execute this code. It appears that in this case, it does not work.
Best Regards,
Herbert
I'd imagine you can write query without using MySQL variable, using correlated query for cumulative sum column.
See link for some sample (Tom H's post).
https://stackoverflow.com/questions/439138/running-total-by-grouped-records-in-table
Another option may be to do cumulative sum calculation in PowerBI and not at query stage.