Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created several data flows using azure blob storage and then linked them to another data flow that combines them via linked entities. I do some transformations from queries that reference the linked entities. The problem is, now that I'm not using azure blob storage in the linked entity data flow it still appears in the settings of that data flow.
Is there a way to remove that reference from the settings? Or, do the linked entities still pull data from the original source; that is, the azure blob?
Thanks!
If you go to https://app.powerbi.com/groups/ you should be able to remove Data sources from the Workspace
I thought that I found a solution here: https://learn.microsoft.com/en-us/power-query/dataflows/troubleshooting-dataflow-issues-connection-t...
... alas, it did not work for me. Maybe it will work for someone else.
It is the end of 2022 and we still have this issue...
Hi, your solution worked for me when it came to database connections (i.e. ODBC, Redshift, SQL, etc) but not for web connections, such as sharepoint links. I did find a method that worked for me, so hopefully it could help you or others:
Hope that helps
Thank you, it works for me
Hi JayWhy,
Your solution works just great! You have saved me a lot of grief. Thank you so much for your response!
Have a great day!
Slava
Hi all,
I've just created an idea that you can vote on! Please find it here: Microsoft Idea (powerbi.com)
Hi,
I'm also having the same issue. Can anyone help or is it possible?
Hi,
I'm also facing the same problem. Please support on this topic.
I had the same issue. You cannot remove datasources from Dataflows....thats really a missing feature / bug.
the workaround is to download the JSON, then import the JSON again (it will duplicate your dataflow, but without the obsolete data source). then you can rework your dataflows that might connect to (depend on) this dataflow, and after that remove the old dataflow.
Yes, that seems to work. Unfortunatly, a new guid will be created and I have to alter subsequent dataflows which reference this one, and have to wait again for hours for validation.
Later in production when people use this dataflow, the workaround won't help, since they reference by guid as well.
Hi @Anonymous
When you link entities between dataflows, you can reuse entities that have already been ingested, cleansed and transformed by other dataflows owned by others without the need to maintain that data. The linked entities simply point to the entities in other dataflows, and do not copy or duplicate the data.
That means linked entities still pull data from the original source.
Gotcha.
The issue I am facing isn't that the linked entity is or isn't pulling data from the original source. It is that I can't remove a reference to the original source I created in the dataflow after changing it to a linked entity. The dataflow continues to require the blob credentials even though the data flow no longer uses that data source.
How can you remove the data source from the settings area after removing it from the data flow? It still seems to remember the data source in the settings.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.