need help_ power bi, why not showing the data?

[bbsin]

hi 

it's my first try to use Power BI w excel .  

i try to connect it but the data is not showing I not sure why.

Can anyone help:

I am trying to show the year budget, forecast and acutal spending by month of the year, quarter and  comparison of years.

Thank you

[Royel]

Need to do few things to identify the problem. 
1. You can give some screenshots of your source data file that show each table has some data. 

2. than, create a new power bi file and import one data table at a time, and check whether you have data or not. 

3. If all tables data are shown in the data view tab then go for table relationship creation.  [do not create multiple relation in taables]

4. As if you do not get the data yet, you could reinstall power bi or report the problem to power bi. 

Let me know, what is the progress?

[amitchandak · Accepted solution]

@bbsin , Sort on some columns and check. I doubt there are empty rows.

remove them in power query

Remove Empty and Remove duplicate Rows (Power Query) : https://youtu.be/Hc5bIXkpGVE

[bbsin]

thank you I will try it 

now I can see the data.