Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to create a data flow with the source for the entities being IBM Netezza. I have been advised i can create a blank query and copy the M code from my connection in Power Query however i am getting the below error:
Expression.Error: The import Netezza.Database matches no exports. Did you miss a module reference?
This is the query code:
let
Source = Netezza.Database("metis", "adw_prd", []),
ADWPRD = Source{[Name = "ADWPRD"]}[Data],
DS_DAILY_SALES_KW1 = ADWPRD{[Name = "DS_DAILY_SALES_KW"]}[Data],
#"Filtered Rows" = Table.SelectRows(DS_DAILY_SALES_KW1, each Date.IsInPreviousWeek([CALENDAR_DATE])),
#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Net Sales Value", each [GROSS_VAL] - [TOT_MD_VAL] - [REFUND_VAL])
in
#"Added Custom";
Any ideas please?
Hi @Anonymous ,
Dataflow does not support this data source. You can refer the documentation:
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Our account manager at Microsoft has advised that we can get around this by using the M code from the PBI Desktop connection and using this in a blank dataflow query? Is this not possible?
Hi @Anonymous ,
I researched it and it is for this reason that Dataflow does not support this data source.
“You can view the available data sources by selecting Get Data from the dataflow authoring tool, which then displays a dialog for selecting the categories and each data source, as shown in the following image.”
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please check with your account manager if this data source is available in dataflow.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
52 | |
35 | |
32 | |
30 | |
25 |