Forum Discussion

romals29's avatar
romals29
Helper II
4 years ago

Table is not visible in data source

Hi I have added a new table in my local MySQL database but the new table is not available when I connect the same database in Power BI desktop. How to sort out this issue. May you please help me o...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

- clear Power BI cache

- specify another table first and then modify the Power Query code to your tabe

 

romals29's avatar
romals29
Helper II
4 years ago

Hi lbendlin

 

I cleared cache in power bi desktop but still the table is not visible

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Is there anything special about the new table? Binary or spatial Field types?

    • romals29's avatar
      romals29
      Helper II
      4 years ago

      No its just a simple table just has one INT column and one VARCHAR column

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Have you tried to specify the table name manually in Power Query as I had recommended?