Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI

hi, I am trying to import an excel file which has grouping & hyperlinks .It doesnt load properly into Power BI. Can any one assist ?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Liang,

    I increased the cache limits (was set to default) - still had the same issue . I had to copy and paste into another workbook and then removed the hyperlinks maually befor loading into BI.

     

    Thanks for your advise.

7 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,


    Can you please share some screen shot for better to understand your issue?

     

    Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

      Hi , Please see below . I have a few issues loading and extracting correct information

      1.Doesnot load (takes for ever) - I just want the cell values to transfer across (not hyperlinks or outline)

      2.Some of the cells are formatted in custom format i,.e "Size" colum has values like   3.2 TB ,so the cell  vaule reads 3.2 but I need the unit of measure so I can convert all into one unit.

       

      Thanks in advance

       

      Sample

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        Anonymous ,

         

        I tried to replicate your issue and I haven't encountered any issue yet. Check below screen shot for input excel and PBI desktop.

         

        Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
    Hi Anonymous @
     
    You can try to increase the cache limits.
    1. Click Settings->Options->Global->Data Load to expose the "Data Cache Management Options".
    2. Try increasing the Maximum allowed (MB):to 16000 (or about double what the current setting is)
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Liang,

      I increased the cache limits (was set to default) - still had the same issue . I had to copy and paste into another workbook and then removed the hyperlinks maually befor loading into BI.

       

      Thanks for your advise.

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago
        Hi Anonymous ,
         
        It's glad that you have solved your problem.
        Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
         
        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.