User Profile
Jarrinf
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1.19-preview" /> Must be: <Sdk Name="Microsoft.Build.Sql" Version="2.2.0" /> After this two fixes are done, it builds and deploy pretty fine.Re: ADLSv2 some Shortcuts fails with "Not authorized" message using same connection
Hello, thanks for your reply. Folders seems okay, I dropped and create them again, now the shortcuts seems good but the sql endpoint for those tables no. Look at this: This is the SQL Endpoint And this is the shortcut The error in the endpooint shows an error: When I try to resync, (using an admin account), it just raise a DatamartUserNotAuthorized message.ADLSv2 some Shortcuts fails with "Not authorized" message using same connection
I have this "MyLakehouse" Lakehouse with several shortcuts pointing to my Azure Datalake Storage V2 storage, most of my almost 100 shortcuts works pretty fine but there are 4 shortcuts that suddenly fails. Data source errorCOM error: Azure.Storage.Blobs, Error in Stored Credential Operation - {"error":{"code":"ArtifactConnection_InsufficientPermission","pbi.error":{"code":"ArtifactConnection_InsufficientPermission","details":[{"code":"ArtifactConnection_InsufficientPermission","detail":{"type":1,"value":"User does not have sufficient artifact permission Read to perform the artifact connection operation."}}],"exceptionCulprit":1}}}. Status: 401 (Unauthorized) ErrorCode: Unauthorized Content: <?xml version="1.0" encoding="utf-8"?> <Error> <Code>Unauthorized</Code> <Message>Error in Stored Credential Operation - {"error":{"code":"ArtifactConnection_InsufficientPermission","pbi.error":{"code":"ArtifactConnection_InsufficientPermission","details": When checking the SQL Endpoint for this fails, I can see this error: Table name mae_tiempodia_1 Error code BadRequest Error subcode "Bad Request".. Trying to query the table this is the error: But, other tables in the same storage using same connection works pretty fine.. Any idea?
