Connect serverless SQL pool and Power BI using a data base user
Hello Microsoft Q&A,
I have the following problem:
I want to use Power BI to get some insights about my data in my Azure Data Lake Gen2. I have created a serverless sql pool and in that pool I created a bunch of external tables. I was able to query these tables via Power BI and my Microsoft Account:
But I want to use a data base user:
I'am able to see the tables in Power BI but get the error DataSource.Error: Microsoft SQL: Content of directory on path 'https://data_____________.dfs.core.windows.net/default/staging/uir/____________/backend_Case/_delta_log/.' cannot be listed.
, when I try to import the data:
Is it possible to create an data base user, so that I'm able to import the data to Power BI using this user. I used the following script, to create the user:
CREATE LOGIN UIR_PowerBIReports WITH PASSWORD = '*';
CREATE USER UIR_PowerBIReports FROM LOGIN UIR_PowerBIReports;
GRANT CONNECT TO UIR_PowerBIReports;
ALTER ROLE db_owner ADD MEMBER UIR_PowerBIReports;