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

[cst_bi]

Hi experts,

Pre-condition :

'Power BI dataflows (legacy)' setting with privacy level is 'public'

Cases :

Somehow in our dataflow can't show the table with error occured : 

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

It happening with random table

When I 'configure connection' and click 'connect', nothing happened (error still exists)

But when I 'configure connection' and 'edit connection'

And then 'sign in'

 

The data table will show as below

But this scenario didn't last long because when I refreshed a few times, the table returned to its error state :

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

These scenario above updated the 'Power BI dataflows (legacy)' setting to privacy level 'private'

So what is going on? 

Kindly please give advice to resolve it

Thank you

Sincerely,
Oviedityanto

[cst_bi]

@Anonymous , @Anonymous 

[cst_bi]

update : 

We have removed the data gateway 'Power BI dataflows (legacy)' and create new one. The default privacy level is 'none'

Still the problem occured when edit the dataflow

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

[Anonymous]

Hi @cst_bi 

Can you save dataflow with new dataflow connector ? Or it only happened with Power BI dataflows (legacy) ?

Best Regards,
Community Support Team _ Ailsa Tao

[cst_bi]

Hi @Anonymous ,

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

Sincerely,

Oviedityanto

[cst_bi]

Hi @Anonymous ,

Today I've create new dataflow using new dataflow connector (not legacy) and compare them, as the picture below

The result is dataflow that use new dataflow connector (not legacy) show no error (right picture). The Power BI dataflows (legacy) still have error credential (left picture) as the picture below

Why? If the only solution is to create new dataflows using new dataflow connector (not legacy), it would be a painful thing to duplicate hundreds of dataflows

Sincerely,

Oviedityanto

[GTS_ONE]

We're seeing the exact same thing happening in our environment.  I very much agree that having to migrate hundreds of our dataflows to the new connector would not be very practical.  We really need a solution for this.

[Anonymous]

Hi  @cst_bi 

Please connect to dataflow with dataflows (legacy) connector in PBI Desktop to see what errors are reported?

Best Regards,
Community Support Team _ Ailsa Tao

[gpfox]

Please fix this error ASAP Microsoft! This is surely a major issue with a huge impact for a lot of people! Entire solutions depend on Power BI Dataflows. Also please make sure that the lineage view still works if we switch to the new Power Platform Dataflows connector, that is one of the main reasons I didn't switch yet.

[cst_bi]

Hi @Anonymous ,

There's no error when connect to dataflow with 'dataflows legacy' connector in PBI Desktop

Now dataflow with 'dataflows legacy' connector is show no error

But what is the best pratice for this connector? Should we migrate all connector from 'dataflows legacy' to 'dataflow power platform'? Or maybe this error can happen in future, so we must migrate from connector 'dataflow power platform' to connector 'dataflow microsoft fabric'?

Sincerely,
Oviedityanto