Forum Discussion

QooT's avatar
QooT
Frequent Visitor
1 year ago
Solved

Cannot acces Tabels in Dataflow Gen2 from Excel

Hi, I have an Excel File with connection to Dataflow Gen2, query as simple as just load table data. let Quelle = PowerPlatform.Dataflows(null), Workspaces = Quelle{[Id="Workspaces"]}[Data], Wo...
Need Help
  • QooT's avatar
    QooT
    1 year ago

    Problem solved.

    Reason was firewall rule wchich was blocking connection to SQL.

    It seems that behind the scenes connection to dataflow Gen2 is turned on the fly into connection to the staging SQL database.

MasonMA's avatar
MasonMA
Super User
1 year ago

HI QooT 

 

This might mean you would need to recheck the data source permission for SQL Server that your Dataflow Gen2 is trying to connect to. A couple of points you can look at, 

1. Gateway Configuration:

If the SQL Server connection in the Dataflow Gen2 is using an on-premises data gateway, ensure the user has access to the gateway and the data source in it.

2. SQL Server Permissions:

Check if the SQL Server is using Windows authentication or SQL authentication, and whether the user’s credentials are valid.

3. Credential Settings in Power BI Service:

Under Data source credentials in Dataflow Gen2 settings , check if the authentication method is set to organizational account and whether the user has signed in.

 

Hope this helps:)