Power BI

[Anonymous]

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

[V-lianl-msft]

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 · Accepted solution]

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]

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.

[Tahreem24]

@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]

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]

@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!

[Anonymous]

  Ok . The file is 40 MB .I tried to limit the number of rows to 10 and it loaded fine .However when I load the 500k + rows it is causing issues . I can try sending a sample of the file not sure how I can send it through.