Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I an trying to enable secure access to data in S3 from Power BI. I am using AWS Gateway API to access csv files in S3 bucket.
I am able to pull the data in locally, but I get an error when I try to refresh it after publishing it. I have tried to use relative path and the API is configured to return 200 code when accessing the public root. However, it still errors out when I try to refresh the data in the cloud. I get an error that says that the first column of the dataset cannot be found, which means it's probably returning an empty dataset during refresh. How can I fix this?
This is the beginning of my code in the query editor:
let
Source = Csv.Document(Web.Contents("https://url",
[Headers=[#"X-API-KEY"="XXXXX"],
RelativePath="/folder%2Ftest.csv"]),
[Delimiter=",", Columns=15, Encoding=1251, QuoteStyle=QuoteStyle.None])
Solved! Go to Solution.
Hi @Anonymous ,
I think this issue should related to AWS configure/policy.
As document said, power bi service will use service bus to access correspond datasource, they are not static addresses. AWS server may block these requests if you not add them to whitelist.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I think this issue should related to AWS configure/policy.
As document said, power bi service will use service bus to access correspond datasource, they are not static addresses. AWS server may block these requests if you not add them to whitelist.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.