Forum Discussion

PolinaOr's avatar
PolinaOr
Icon for Helper I rankHelper I
3 months ago
Solved

Dataflow passing validation check, but has hidden errors

Hi, everyone   I am trying to connect to my personal OneDrive Document and organisational Lake Dataset.   I have tried using Dataflow recently, which actually worked 2 times when loading it (out ...
General Comment
Need Help
  • Lodha_Jaydeep's avatar
    Lodha_Jaydeep
    3 months ago

    Hi PolinaOr,

    Thanks for reaching and outlined the steps.

     

    The issue is related to the permission on the gateway connection, cna you try to do below things?

    1) connect the lakehouse in SSMS which was used in the connection "Lakehouse LH_Gold" which you can find from the gateway settings.
    If connection is working in the SSMS or not please confrom.
    2) If not you can ask BI Team/Admin to add your user in the lakehouse and giving you the correct access. Then you try to connect this lakehouse with the connection mentioned.

     

    Please consider as an accepted solution if helps or give some kudos.

Lodha_Jaydeep's avatar
Lodha_Jaydeep
Icon for Solution Sage rankSolution Sage
3 months ago

Hi PolinaOr,

Thanks for reaching and outlined the steps.

 

The issue is related to the permission on the gateway connection, cna you try to do below things?

1) connect the lakehouse in SSMS which was used in the connection "Lakehouse LH_Gold" which you can find from the gateway settings.
If connection is working in the SSMS or not please confrom.
2) If not you can ask BI Team/Admin to add your user in the lakehouse and giving you the correct access. Then you try to connect this lakehouse with the connection mentioned.

 

Please consider as an accepted solution if helps or give some kudos.

  • PolinaOr's avatar
    PolinaOr
    Icon for Helper I rankHelper I
    3 months ago

    Hi,

     

    I have contacted BI team and they granted me access. It works now when loading basic data, but I have to essentially now check where exactly dataflow is failing. I will be building steps up to see where it breaks.