Power BI
NewLink/Unlink Azure Data Lake Store Gen2 storage accounts to Power BI Service Dataflows
on 11 Jan 2019 05:19:35
Give the possibility to unlink a ADLS2 currently linked to a PowerBI Service Dataflow,in order to enable cleaning of test enviroment and storage account rename.
- Comments (4)
RE: Link/Unlink Azure Data Lake Store Gen2 storage accounts to Power BI Service Dataflows
This makes it very difficult to set up a POC without having the final production architecture in mind and locks us in; thus we are hesitant to start working with PowerBI data flows to the data lake even though we have use cases for it.
RE: Link/Unlink Azure Data Lake Store Gen2 storage accounts to Power BI Service Dataflows
From what I see from https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2. This seem not supported.
Question: What if I had previously created dataflows in a workspace and would like to change their storage location?
Answer: You cannot change the storage location of a dataflow after it was created.
I believe it is on the TODO list of dataflow team, and I recommend we vote more on this functionality to get more attention.
RE: Link/Unlink Azure Data Lake Store Gen2 storage accounts to Power BI Service Dataflows
This is required to allow cleanup / production build of a proof of concept that has been setup on a developers azure tenancy under their Visual Studio subscription rather than in the companies azure tenancy.
Elisa, were Microsoft support able to unlink the Power BI service from the data lake storage by scripting up a fix? Did you go down the path of raising a ticket?
RE: Link/Unlink Azure Data Lake Store Gen2 storage accounts to Power BI Service Dataflows
I didn't realize that the storage account couldn't be changed, and so I deleted it in preparation of switching to a different storage account. Unfortunately now my dataflow storage is locked into a storage account that no longer exists. Thus I cannot use dataflows now.
UPDATE: I was able to create a storage account using the same name as the account that I deleted. I followed the steps to use it as dataflow storage, and it works. The original data is gone (as I expected) but the functionality of dataflows has returned. I can now create new dataflows, save them, and access the data on Azure Storage Explorer.