Cannot find the CREDENTIAL error when trying to access the Lake database spark tables from Power BI even if Spark created the credentials and external data sources automatically

Question

I cannot find the CREDENTIAL error when trying to access the Lake database spark tables from Power BI even if Spark created the credentials and external data sources automatically.

When I created a table using Synapse Notebook and checked, I can see that there are credentials and external data source created already.

When I try to create a new credential it says " Operation CREATE EXTERNAL DATA SOURCE is not allowed for a replicated database."

"Cannot find the CREDENTIAL 'https://xxxx.dfs.core.windows.net/silver/Vol1/Assemble/Teams_Delta', because it does not exist or you do not have permission."

The above is the error when i tried to access the spark tables from Power BI and SSMS. Both gave the same error.

When I created the same in serverless pool, It worked.

What's the solution here, it's very confusing.

But my requirement is to use lake database and access the spark tables for our development.

Please suggest a solution here.

How to access Spark tables from lake database in Power BI?

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

You can only create CREATE EXTERNAL DATA SOURCE on sql database...pls see the link below.

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand?tabs=x80070002#operation-isnt-allowed-for-a-replicated-database

Also go through the below answer with links to the step-by-step docs which might help you with basic questions that might arise when you try to implement.

https://learn.microsoft.com/en-us/answers/questions/454771/how-can-i-access-a-table-of-spark-databse-when-cre

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.