0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

Power BI: エラー: 『指定された値は無効な CRLF 文字を含んでいます』の対処

Posted at

背景

久しぶりに確認したレポートでを吐いていたエラーが以下

2021-12-17_12h13_51.png

自宅では再現しないものの、エラーと対処法の記録を残しておく

原因箇所

Power Query を VS で Debug 出来るようにしないとね

Error
Excel.Workbook(Web.Contents("https://****/SampleFile.xlsx"))

対処法

SharePoint.Contents() を利用するだけ

ただ、アクセス権の問題がある場合には、以下で代用も

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?