Hi,
The current Data warehouse has tables with two different DB schema's. There are already PowerBI Dash-boards using these schema's. Now I want to use the Semantic layer to copy the data (Data Export) to a SQL serverless DB. Everything works fine but I want to override the schema name. In the Semantic layer I have not find any options to change this. Is that correct or is there a way like in the Dataware house layer to change the schema?
Best answer by Christian Hauggaard
Hi
Is there a particular reason why you are using the data export SQL feature rather than adding a new SQL data warehouse and bringing the table in there as a simple mode table? This second option will allow you to control schema
+5Hi
Is there a particular reason why you are using the data export SQL feature rather than adding a new SQL data warehouse and bringing the table in there as a simple mode table? This second option will allow you to control schema
I currently do that but the reason for using the semantic layer was:
In my case I will continue using the solution I have, that is as last step copy the data as simple mode table to the Serverless DB.
+5We no longer have the SQL data export feature in the latest version (it has been deprecated). At the time we released it, I am not sure if simple mode was available. Furthermore, I believe the permissions required for the data export are less, so that might have been a possible use case
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
