User Profile
awbanksh
Microsoft Employee
Joined 2 years ago
User Widgets
Contributions
Re: Writing data from Fabric to SharePoint Online
The other option is to use a Dataverse table as a "bridge" and send your CSV data to Dataverse, then connect Power Automate to Dataverse to then convert it back to a CSV and upload to SharePoint. Not the most ideal solution but it does work and I would argue it's more reliable than dataflow gen2 as it's not as performant in comparison.9.8KViews0likes1CommentFabric Notebook Unable To Connect To Azure SQL Server
I'm trying to connect a Fabric notebook (PySpark) to Azure SQL server using pyodbc but keep receiving the following error when using ODBC Driver 18 for SQL server: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)') Can anyone help? I don't want to input my password into the notebook.Solved3.5KViews0likes5CommentsRe: Fabric Lakehouse Shortcut to ADLS Gen2 Storage Not Working
The authentication method is the same as Dataflow Gen2, I'm connecting through a service principal (SA). I have been give standard level access to the folder path. However, I don't believe I have Storage Blob Data Reader role on the storage account. If I'm able to consume the .parquet files via Dataflow Gen2 doesn't that mean I have Storage Blob Data reader role on the storage account?7KViews0likes0CommentsFabric Lakehouse Shortcut to ADLS Gen2 Storage Not Working
When I try to create a shortcut in Fabric Lakehouse I get the below permissions error. I’ve modified the path a few different ways and still get the same error. Strangely, i'm able to connect to the ADLS Gen2 path through Data Factory, Dataflow Gen2, Power Query, etc. Me successfully connecting to ADLS Gen2 through Fabric - Data Factory: Fabric Lakehouse Shortcut screen: Fabric Lakehouse Shortcut error:Solved7KViews0likes8Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.