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

Hi Ceeeg ,

Are you using power bi legacy (no 1) connector? I've tried updated the connector using power bi dataflow / newer / not legacy (no 2) and the error dissapear

Here's my step to update connector from 'power bi dataflow (legacy)' to 'dataflow'

1. Open dataflow and remember the first table (in my case I choose 'wmsmakloon_transfer_log_natura')

2. Get data from 'dataflow' and select table 'wmsmakloon_transfer_log_natura' and load it. The table name will be 'wmsmakloon_transfer_log_natura (2)'

3. Go to 'advance editor' and copy these 5 line query from table 'wmsmakloon_transfer_log_natura (2)'

4. Now select 'wmsmakloon_transfer_log_natura' table, go to 'advance editor', paste and customise the code

This is my query before in table 'wmsmakloon_transfer_log_natura' :

let
Source = PowerBI.Dataflows(),
Workspace = Source{[workspaceId="19cfed95-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]}[Data],
Dataflow = Workspace{[dataflowId="0100cd6a-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]}[Data],
Entity = Dataflow{[entity="wmsmakloon_transfer_log_natura"]}[Data]
in
Entity

And this is my query after I customise based on table 'wmsmakloon_transfer_log_natura (2)' :

let
Source = PowerPlatform.Dataflows([]),
Navigation = Source{[Id = "Workspaces"]}[Data],
#"Navigation 1" = Navigation{[workspaceId = "19cfed95-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]}[Data],
Dataflow = #"Navigation 1"{[dataflowId = "0100cd6a-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]}[Data],
Entity = Dataflow{[entity="wmsmakloon_transfer_log_natura"]}[Data]
in
Entity

5. If you want to update another tables, copy these 5 line query from table 'wmsmakloon_transfer_log_natura' (which is customised table based on the new power bi dataflow connector). These query will be paste references for other tables

6. Paste it into another tables (picture below is example for table '

wmsmakloon_transfer_log_infion')

  

7. Delete unnecessary gateway 'Power BI dataflows (legacy)'

 

Hi Anonymous ,

 

Please check this case, is it really because of the 'Power BI dataflows (legacy)' connector?

 

Sincerely,
Oviedityanto