Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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;
Hi @AfsarP1 ,
Do you mean that you could only get the information of tables instead of data? Is the"PLEASE SPECIFY HOW TO CONNECT" error from Power BI or from table? To be more clear, you could provide some screenshots.