Power BI Visual won't show any data RRS feed

  • Question

  • Summary: 
    My visual shows no data in Power BI desktop, even though I have clearly data loaded into Power BI.

    I have an estabilished connection between my local MySQL table and Power BI. In that database, I have two tables.

    From time to time, I import new data into the MySQL database. Then I refresh the Power BI desktop manually. I have two visual on the canvas, one uses data from the first table, the other from the second table. It used to work fine, until I refreshed the localhost database the second time. While the visual that uses the first table works fine, the second visual shows no data at the moment. If I right-click and select "show data", it shows no data. However, if I click edit query, there are clearly a lot of data in it.

    It seems to be an unsolved problem for many.

    Please assist, this is very frustrating as it destroys my business.

    • Edited by nawaswohl Thursday, April 25, 2019 9:24 AM formatting
    Thursday, April 25, 2019 9:21 AM