Forum Discussion
Anonymous
7 years agoNot applicable
Custom connector Power Bi
Hello, I need create a new cutom connector for Power Bi. In the code is necessary put conection to the database included user and paswword for to connect automatically. In the next try i p...
- 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
7 years agoNot applicable
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") }
];when trying to connect the message comes out: "specify how to conect" when trying to put the credentials for to connect to database.
I cant to connect to database.
If i open a new power bi and i do new login to the same database the login is successfully.
Anonymous
7 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