Forum Discussion
MySQL connector doesn't show new table on schema
Hello! I have a Power BI report that works fine. I do a lot of data manipulation in Power BI as there are many issues with the data (removing spaces, formatting, dividing columns, etc). So ideally I don't want to start from scratch.
The problem is that a new table was added and I can't get it to show - I tried refreshing and everything. If I create a new Power BI and do a new connection using the same details, I can see this new table.
Do I need to do something to show this table? And if I need to start again, is there an easy way to bring all the data manipulation, DAX columns, etc that I've created?
Any help would be great please. Thank you so much! 🙂
Thank you everyone. I tried most of the solutions below without luck, but it got me looking at the right places, so thank you!
It worked by me creating a new data source, but adding the same one as the existing one and selecting the 'new' table. That finally added the table to my schema and it still kept one source (I was worried that it'd see the new one as a new source even though it's the same as the previous one).
Thank you 🙂
7 Replies
Hi gbaia
Try this and let me know if it works: Go to Transform Data > Data source settings > Change Source, then re-enter your connection details (even the same ones) and click OK.This refreshes the schema and your new table will appear.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡You can go into Advanced Editor and save the query into notepad, which can then be transferred to other reports. The only difference could then be under Data source settings - check the connection has the same settings for both the report that connects and the one that doesn't. Also try stepping through your query to see if it appears at the start but then becomes empty due to a dodgy filter.
Transform data → Power Query
In the Queries pane, click the Source query (or the first query that connects to MySQL)
In the Applied Steps pane:
Click the gear icon on the Source step
The Navigator will open again
The new MySQL table should now appear → select it → OK
To show the new table:
Go to Transform Data
Edit the Source step (gear icon ⚙️)
Re-select the database and click OK
The new table will appear.
🔵If this response was helpful, please accept it as a solution and give kudos to support other community members
Regards,
🔵Rufyda Rahma | MIEHI gbaia,
Have you had a chance to review the solution we shared by DataVitalizer JamieHolding cengizhanarslan Rufyda ? If the issue persists, feel free to reply so we can help further.
Thank you.
Thank you everyone. I tried most of the solutions below without luck, but it got me looking at the right places, so thank you!
It worked by me creating a new data source, but adding the same one as the existing one and selecting the 'new' table. That finally added the table to my schema and it still kept one source (I was worried that it'd see the new one as a new source even though it's the same as the previous one).
Thank you 🙂
Hi gbaia,
Since recreating and reconnecting the table fixed the issue, thank you for providing the solution. Mark your reply as the solution so it can assist other community members who encounter the same problem.
Thank you.
