Hi Team
I've built a data connector using Oauth flow and able to connect successfully to our cloud environment. However, when I try to get the data in Power BI desktop, instead of the actual data it just shows table as the value. Earlier there was an issue where everytime I click on any of our API(in the Power Bi Desktop) it used to load forever. Reading on different blogs, I realised that it was a bug. That issue seems to be resolved.
Unfortunately, I get the result as "table" instead of actual value and I if click on any of the table it says "PLEASE SPECIFY HOW TO CONNECT" whereas I have already authenticated using my windows credentials. Can someone advise what exactly is the issue. I also have my API username and password and kind of feel like these are expected but not sure how to use them in the code with Oauth flow. Can someone advise?
Here is my data source:
[DataSource.Kind = "System" , Publish="System.Publish"]
shared System.Contents = Value.ReplaceType(SystemNavTable, type function (url as Uri.Type) as any);
SystemtNavTable = (url as text) as table =>
let
entitiesAsTable = RootEntities,
// Add Data as a calculated column
withData = Table.AddColumn(entitiesAsTable, "Data", each Systemt.Contents(Uri.Combine(url, [Query])), Uri.Type),
// Add ItemKind and ItemName as fixed text values
withItemKind = Table.AddColumn(withData, "ItemKind", each "Table", type text),
withItemName = Table.AddColumn(withItemKind, "ItemName", each "Table", type text),
// Indicate that the node should not be expandable
withIsLeaf = Table.AddColumn(withItemName, "IsLeaf", each true, type logical),
// Generate the nav table
outputTable = Table.RemoveColumns(withIsLeaf, "Query"),
navTable = Table.ToNavigationTable(outputTable, {"Name"}, "Name", "Data", "ItemKind", "ItemName", "IsLeaf")
in
navTable;
