Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Everyone,
When I'm trying to refresh my data I got this error
An error occurred in the ‘Sample File’ query. DataSource.Error: Web.Contents failed to get contents from 'https://xxxx-my.sharepoint.com/personal/xxxx/_api/web/lists/getbyid('bc70fb34-3f97-4025-af5d-03235fa33b8e')/RenderListDataAsStream' (500): Internal Server Error Details: DataSourceKind=SharePoint DataSourcePath=https://xxxx-my.sharepoint.com/personal/xxxxx Url=https://xxxx-my.sharepoint.com/personal/xxxx/_api/web/lists/getbyid('bc70fb34-3f97-4025-af5d-03235fa33b8e')/RenderListDataAsStream
and here below the M editor
let Source = SharePoint.Files("https://xxxxx-my.sharepoint.com/personal/xxxxxxxx", [ApiVersion = 15]), #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "file_2.csv")), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content"}), #"Invoke Custom Function1" = Table.AddColumn(#"Removed Other Columns", "Transform File from Query1", each #"Transform File from Query1"([Content])), #"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File from Query1"}), #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Query1", Table.ColumnNames(#"Transform File from Query1"(#"Sample File"))), #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"datahora_file", type datetime}, {"diasemana_file", type text}, {"unidade", type text}, {"caixa", type text}, {"garcomlider", type text}, {"atendimento", type number}, {"ambiente", type number}, {"cafe", type number}, {"comida", type number}, {"bebida", type number}, {"preco", type number}, {"amor", type number}, {"nome_cliente", type text}, {"email_cliente", type text}, {"comentario_cliente", type text}, {"nosso_comentario", type text}, {"data_file", type date}, {"hora_file", type number}}) in #"Changed Type"
I can open the sharepoint folder itself properly without any problems.
Solutions approached till now without any effect:
- I changed ApiVersion to 14 instead of 15
- I removed the ApiVersion
- I cleared the permissions and add it again
- Try to connect from scratch to the same folder, same error
Thank you
Solved! Go to Solution.
It seems there was a problem in the data source in addition to this ApiVersion thing.
I recognized there is additional row under my filtered files [Error - Error] and it is not filtered out. So, below steps to eliminate this error record from ruining my data, and I had so many files in different dashboards. So, I went through these possibilities here
and then folow any other steps you want to apply on your data. and it worked.
For me the error has appeared when I try to import a (growing) list of Sharepoint files. At some point, the 500 error will appear, and deleting or archiving a set of files will generally eliminate the error. I suspect it is the number of files that are tried to be imported, but I am not aware of a concrete limit.
You can try disabling "parrallel query processing" and "background data" in the query options. This worked for me.
It seems there was a problem in the data source in addition to this ApiVersion thing.
I recognized there is additional row under my filtered files [Error - Error] and it is not filtered out. So, below steps to eliminate this error record from ruining my data, and I had so many files in different dashboards. So, I went through these possibilities here
and then folow any other steps you want to apply on your data. and it worked.
I had a similar erro, but the issue was in the filename. It has a % in the name. Make sure you don't use special symbols in the file path and filenames.
Keep rows solution does work but I can't get apply a filter before hand to sort by date modified due to the error row.
I figured out the problem and solved it.
I will make another comment with the solution
Amratya,
Please how did you solve the problem? Benn having same issue for a while now
It seems there was a problem in the data source in addition to this ApiVersion thing.
I recognized there is additional row under my filtered files [Error - Error] and it is not filtered out. So, below steps to eliminate this error record from ruining my data, and I had so many files in different dashboards. So, I went through these possibilities here
and then folow any other steps you want to apply on your data. and it worked.
old post..., but how did you fix this issue?
we had the same issue ~2 months ago, then it magically started refreshing without making any changes to the report or SharePoint. now, the issue is back and the magic still hasn't happened.
It seems there was a problem in the data source in addition to this ApiVersion thing.
I recognized there is additional row under my filtered files [Error - Error] and it is not filtered out. So, below steps to eliminate this error record from ruining my data, and I had so many files in different dashboards. So, I went through these possibilities here
and then folow any other steps you want to apply on your data. and it worked.
Hello my org is having the same issue. We chnage nothing and 1/30 refreshes and it randomly works. This has been going on from 3/22 to current
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
103 | |
64 | |
60 |