Power BI dataflows (legacy) keep error : The credentials provided for the PowerBI source are invalid

Hi Anonymous ,

This error occurs in dataflow. The dataset is normal

It's random error, please see the images below

1. as-is dataflow

dataflow : mps_source

table : _ppic_pemetaan_card_mps

error : The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)

2. export mps_source into json file and import it to the same workspace

dataflow : mps_source(1)

table : _ppic_pemetaan_card_mps

error : -

This new dataflow "mps_source(1)" is still have no error free

The error "The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)" occured on another table in this dataflow

In another example cases :

1. I have 3 table 'knsppk', 'oespb0' and 'wmsmakloon_transfer_log' in the same dataflow. The data display no error when open these table

But when i create new table using table combine of  'knsppk', 'oespb0' and then merge into 'wmsmakloon_transfer_log', the error occured at step 'Expanded wmsmakloon_transfer_log' as picture below

this is my step which error exists :

let
    Source = Table.Combine({knsppk0, oespb0}),
    #"Inserted text before delimiter" = Table.AddColumn(Source, "jenis_surat", each Text.Select([no_transaksi], {"A".."Z"}), type text),
    #"Merged queries" = Table.NestedJoin(#"Inserted text before delimiter", {"no_transaksi"}, wmsmakloon_transfer_log, {"c_no_transaksi"}, "wmsmakloon_transfer_log", JoinKind.LeftOuter),
    #"Expanded wmsmakloon_transfer_log" = Table.ExpandTableColumn(#"Merged queries", "wmsmakloon_transfer_log", {"dt_user"}, {"dt_user"})
in
    #"Expanded wmsmakloon_transfer_log"

My gateway connection for this dataflow is using 'Power BI dataflows (legacy)' as the picture below

In the picture above, my workspace is similar to 'module A' which is get the table source only from another workspace (workspace : data staging)

Sincerely,

Oviedityanto