Forum Discussion

RicardoCorreia's avatar
RicardoCorreia
Regular Visitor
8 years ago
Solved

Unable to view data

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 ...
Need Help
RicardoCorreia's avatar
RicardoCorreia
Regular Visitor
8 years ago

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's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    RicardoCorreia,

     

    Try to select Remove Blank Rows in Query Editor.

    • RicardoCorreia's avatar
      RicardoCorreia
      Regular Visitor
      8 years ago

      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's avatar
        v-chuncz-msft
        Community Support
        8 years ago

        RicardoCorreia,

         

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