Forum Discussion

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
6 years ago

Data loaded and seen inside query editor (now Transform Data) but not in report!

Hi all,   I've been facing a weird issue, I have a report with excel source and lately with the updated replaced excel sheet, when I refreshed the report, the new dataset along with the date column...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi k3rz0rg 

If this happens in other pbix file?

and if you could uninstall and reinstall the power bi desktop and try it again.

or please try to use this datasource to create a new report to see if it works well.

 

Regards,

Lin

  • k3rz0rg's avatar
    k3rz0rg
    Icon for Advocate III rankAdvocate III
    6 years ago

    Hi v-lili6-msft , 

    this doesn't happen to the other reports or .pbix files!

    This happened to this report previously and I just copied all codes from advanced editor of each of the table from the previous faulty report and recreated the new report, worked fine for few times then this again! ğŸ˜•

    All of it's sources are excel file and there are about 30+ excel connected to it, however, I don't think source is the issue as all the data is in correct order inside query editor!

    I did try uninstalling and reinstalling the pbi and currently using the latest version of it. 

     

    -k3