Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data refresh error

HI All, Ive built a power bi report, the data is placed on MS Teams channel in specific folder in a form of xlsx with 2 sheets. Last 2 months there was no problem refreshing it, but today I can s...
Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI Anonymous ,

     

    The error complains about some data format error.

    Can you try one thing:

    1. Remove Expanded Table step from your applied steps
    2. Again go and click on the icon below to add the expanded step: 

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Anonymous ,

 

when you modify file extension from .xls to .xlsx, what error do you get?

This should ideally fix this issue.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Pragati11 

 

I didnt had to change it, as it was xlsx from the beggining.  As you can see this was already an xlsx

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    Hi Anonymous ,

     

    In that case, did any permission change happen on this excel file?

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Pragati11 

       

      Nothing I am awere of, the excel was just downloaded from the files, user overwrite the data with new one, and upload it again. Unless I can change it somehow? The strange thing is that when I am loading the same file to new/empty powerbi report it loads perfectly

      • Pragati11's avatar
        Pragati11
        Super User
        4 years ago

        Hi Anonymous ,

         

        Is it just one file or multiple files?

        How are you getting this file in Power BI - using Excel type data-source connection?

         

        Thanks,

        Pragati