Forum Discussion
Datamart Auto Generated Dataset
Hi. Let's see.
1) Yes. It generates a DQ dataset connected to the datamart. It won't have a schedule refresh because it's DQ to the datamart.
2) It won't have XMLA Endpoint features. You can't connect with a third party tool. It's only for reporting and datavisualization purpose. The datamart should handle the modeling. If you really want to build something with PowerBi Desktop you should know the Datamart it's actually an Azure SQL Database. You can get the instance from the configuration and connect a Power Bi Desktop getting data from Azure SQL Database and your Azure AD credentials. Then you can even import the data and have all the classic PBI features.
3) I don't have much to say here. I haven't tried with that many rows yet. You can check if you can find a configuration in the DQ dataset to get rid off or reduce the Cache that usually has a DQ dataset.
I hope that helps,
Hi. Let's see.
1) Yes. It generates a DQ dataset connected to the datamart. It won't have a schedule refresh because it's DQ to the datamart.
2) It won't have XMLA Endpoint features. You can't connect with a third party tool. It's only for reporting and datavisualization purpose. The datamart should handle the modeling. If you really want to build something with PowerBi Desktop you should know the Datamart it's actually an Azure SQL Database. You can get the instance from the configuration and connect a Power Bi Desktop getting data from Azure SQL Database and your Azure AD credentials. Then you can even import the data and have all the classic PBI features.
3) I don't have much to say here. I haven't tried with that many rows yet. You can check if you can find a configuration in the DQ dataset to get rid off or reduce the Cache that usually has a DQ dataset.
I hope that helps,
Is there any way to delete autogenerated dataset ?
I'm having a similar issue. The Dataset is supposed to be a DQ to the Datamart but it will not show the current data in the Datamart. The Dataset seems to be locked to the data loaded when it was first generated from the Datamart. I cannot seem to get it to update. Is this a permission issue maybe?
