Re: Create Data Flow from IBM Netezza

Anonymous · ‎03-27-2020

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?

v-lionel-msft · ‎03-30-2020

Hi @Anonymous ,

Dataflow does not support this data source. You can refer the documentation:

Data sources for dataflows

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.

Anonymous · ‎03-30-2020

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?

v-lionel-msft · ‎04-01-2020

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.