You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have been searching online and can't find much doumentation around working with local files. Here is my question/issue.
In my connector I create the credentials for my DataSource.Kind. The shared function is supposed to retrieve a local fileand run a custom unzip function. This is where I run into the credentials problem. The query errors out becuase it needs credentials for the local file, but there is no way to set them.
Is this by design or am I doing something wrong?
The unzip function works, I use it as a stand alone function in Excel PowerQuery and Power Bi, so the function is not broken. I can't access the file.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I have been searching online and can't find much doumentation around working with local files. Here is my question/issue.
In my connector I create the credentials for my DataSource.Kind. The shared function is supposed to retrieve a local fileand run a custom unzip function. This is where I run into the credentials problem. The query errors out becuase it needs credentials for the local file, but there is no way to set them.
Is this by design or am I doing something wrong?
The unzip function works, I use it as a stand alone function in Excel PowerQuery and Power Bi, so the function is not broken. I can't access the file.
` [DataSource.Kind="IntakeForm", Publish="IntakeForm.Publish"]
shared IntakeForm.ZipFormat = (fileName) =>
let
getFileContents = File.Contents(fileName),
extractArchive = File.Unzip(getFileContents)
in
extractArchive;
// Data Source Kind description
IntakeForm = [
Authentication = [
Windows = [],
Anonymous = []
]
]; `
Error message:
Credentials are required to connect to the IntakeForm source. (Source at {"fileName":"E:\local\file\file.zip"}.)
The credential is there... I think.
{ "DataSource": { "Kind": "IntakeForm", "NormalizedPath": "{\"fileName\":\"E:\\\\local\\\\Projects\\\\file\\\\\file.zip\"}", "Path": "{\"fileName\":\"E:\\\\local\\\\Special Projects\\\\file\\\\file.zip\"}" }, "AuthenticationKind": "Windows", "PrivacySetting": "None", "Properties": {} }Beta Was this translation helpful? Give feedback.
All reactions