Unable to view data

[RicardoCorreia]

Hi there,

Can you please advise how i can overcome the following issue:

I have several files related but some of them are unable to relate due to missing data. The date is there because when i edit the querie i can see the information (i've changed all to unique text or number but it still not retrieving data. I also deleted the files and included and still not working). There are no errors on the queries and the files are not that big so i have no idea how i can overcome this issue (i have version 2.51 64bit)

Thanks in advance for your support! 

 

[v-chuncz-msft]

@RicardoCorreia,

Check "Include in report refresh" in the Query Editor.

https://community.powerbi.com/t5/Desktop/All-queries-not-refreshing/m-p/235864#M104964

[RicardoCorreia]

Good morning @v-chuncz-msft

Thanks for the reply!

The "Include in report refresh" was already sellected and it still not solving the issue... I know that probably is something really easy

All the other files and connections are working fine only this one is giving me Headache from the begining...

Thanks again!

ricardo

[v-chuncz-msft · Accepted solution]

@RicardoCorreia,

Try to select Remove Blank Rows in Query Editor.

[RicardoCorreia]

Hi @v-chuncz-msft,

Problem solved thanks! It was probalbly some bug. I changed .xlsx to .csv and it worked

Have a nice week,

ricardo

[v-chuncz-msft]

@RicardoCorreia,

By the way, to help close this thread, accept the solution above. Your contribution is highly appreciated.