Share
Report
30Hi
I can now use the XRMToolbox to generate O data queries that I can use in power BI
let
Source = OData.Feed(ServiceRootURL, null, [Implementation="2.0"]),
entity_table = Source{[Name = "accounts", Signature = "table"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(entity_table,{"new_accountid","name","accountnumber"}),
#"Renamed Columns" = Table.RenameColumns( #"Removed Other Columns",{{"new_accountid","Account ID"},{"name","Account Name"},{"accountnumber","Account Number"}})
in #"Renamed Columns"
Which is great but I don't really want to put it straight into Power BI. I want to put it into a SQL table using Azure Data Factory.
Can I use the XRMToolbox to help me create a linked service and data set for Azure data factory?
At the moment I can only see a use for it to create queries for Power BI?
All responses (
Answers (
