Forum Discussion

NandanHegde's avatar
NandanHegde
Super User
2 years ago

Unable to Access some sources

Hello All, Good day!   I am getting the below error while creating a connection to Azure SQL database and Azure Analysis service :     Same error even for Azure SQL database.   But we a...
Dataflows
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi NandanHegde  - Thanks for using Fabric Community,

As I understand you are facing some issue and unable to connect with Azure SQL database and Azure Analysis service using DataFlow.

When I tried to do a repro, I am able to connect with Azure SQL database using DataFlow.
I am attaching the screenshot for reference -



Can you please check if you provided necessary permissions inorder to access the service?



In addition, can you please share details of your authentication type?

Hope this helps. Do let us know if you have any further queries.

  • NandanHegde's avatar
    NandanHegde
    Super User
    2 years ago

    Hey,  As stated above; I am able to access an azure SQL DB via Data pipeline but the same DB I am unable to access via Dataflow Gen 2.
    So what is the cause of that ?
    I am using Org Account auth

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi NandanHegde ,

      It looks little strange, I am able to connect perfectly when I tried using Org Account auth.
      Can you please confirm did you successfully ran the copy data activity in the pipeline and able to load the data into Lakehouse?

      The above error looks like some permission issue.