Forum Discussion
Using Custom Data Connector to read Local .txt File
I want to use my custom connector in Power BI Desktop to make calling the API I plan on using easier.
I have gotten it to work normally in Power BI using the query editor inside it or the import Text/CSV data source, but I wanted to see if I could have this custom connector read a text file to get a user's authentication token without having to do those other ways.
Would placing these files on a SharePoint or OneDrive instead be an option for you? It would save you enormous amounts of future headaches.
I could but the reason I wanted to use a local file is to avoid the step of having the user sign into anything.
Do you know how I would go about accessing the file either through their local file system or OneDrive so I can compare the two?
Use the "SharePoint Folder" connector for OneDrive.
Sadly, Azure Keyvault is not a viable option yet.
Is there a way I could replicate the functionality of the SharePoint Folder connector inside a custom connector using the Power Query SDK?
Ideally with my custom connector the idea is the user would only need to include whatever parameters they want in the HTTP request and it would handle getting the authorization key from either the text file located on their computer or OneDrive.