Forum Discussion
Custom connector Power Bi
- Anonymous7 years ago
Anonymous,
Why not use built-in Oracle connector in Power BI Desktop? As per this article, for custom connector, Currently, a limited set of data source functions have been enabled to support extensibility. It doesn't support using Oracle.Database function.Web.Contents
OData.Feed
Odbc.DataSource
AdoDotNet.DataSource
OleDb.DataSource
Regards,
Lydia
Anonymous,
I don't think it is possible to hard-code the usename and password in the code to make login automatically in custom connector.
You can define different authentication types(OAuth, Key, Windows, Basic (Username and Password), and anonymous credentials) following the guide in this article, but you still need to manually enter username and password when using the custom connector in Power BI Desktop.
Regards,
Lydia
ok, thank you,
Now, i put:
section HelloWorld;
[DataSource.Kind="HelloWorld", Publish="HelloWorld.Publish"]
shared HelloWorld.Contents = (optional message as text) =>
let
qry = "Select.....",
Source = Oracle.Database("ORADES11", [HierarchicalNavigation=true, Query=qry])
in
Source;
HelloWorld = [
TestConnection = (dataSourcePath) => {"HelloWorld.Contents"},
Authentication = [
Anonymous = []
],
Label = Extension.LoadString("DataSourceLabel")
];
HelloWorld.Publish = [
Beta = true,
ButtonText = { Extension.LoadString("FormulaTitle"), Extension.LoadString("FormulaHelp") },
SourceImage = HelloWorld.Icons,
SourceTypeImage = HelloWorld.Icons
];
HelloWorld.Icons = [
Icon16 = { Extension.Contents("HelloWorld16.png"), Extension.Contents("HelloWorld20.png"), Extension.Contents("HelloWorld24.png"), Extension.Contents("HelloWorld32.png") },
Icon32 = { Extension.Contents("HelloWorld32.png"), Extension.Contents("HelloWorld40.png"), Extension.Contents("HelloWorld48.png"), Extension.Contents("HelloWorld64.png") }
];- Anonymous7 years agoNot applicable
Anonymous,
Why not use built-in Oracle connector in Power BI Desktop? As per this article, for custom connector, Currently, a limited set of data source functions have been enabled to support extensibility. It doesn't support using Oracle.Database function.Web.Contents
OData.Feed
Odbc.DataSource
AdoDotNet.DataSource
OleDb.DataSource
Regards,
Lydia- Anonymous7 years agoNot applicable
ok, thank you