Forum Discussion
Can Not load data for creating a visualization report after connecting MySQL database
Please help with this why this is coming when I'm trying to load the mysql table data from power bi desktop.
8 Replies
Hello munshikhalid ,
instead of load, try clicking on transform data to see where is the error coming from.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you Idrissshatila for your quick response when I'm clicking on Transform data a query editor opens with table data but i wanted to know how can i create a visualization report like a bar graph. I choose a visualize chart but i wanted to plot x axis and y axis. and here i can not apply changes for future uses of result of my query. when i click on apply changes then the same error coming.
yes, true the transform data is the cleaning part of power bi, its called power query, so just try to refresh every table in the transform data so you could understand where the error is coming from thenyou click load data so you could build the visuals.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Please help. I can not load data always dbNull error is showing
