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.
Hi
I have a dataflow and it is telling me that it is "Not configured correctly".
It says I need to add some files to the data gateway list of sources.
However, these files are not in the dataflow and in some cases do not even exist on the file server where they were at some point - they have been deleted in some cases.
What do I need to do to convince the dataflow that it can ignore these and they are not part of the dataflow?
Many thanks
Oliver
Were you ever able to figure out a fix for this?
Hi Anthony
If I recall correctly, I exported the dataflow JSON, deleted the dataflow and then recreated it with the JSON.
Cheers
Oliver
Hi @OliverO ,
If the datasource is in on-premises, you need use an Enterprise Gateway to refresh for both dataset and dataflow.
Since power bi couldn't connect to on-premises data source, it needs Enterprise Gateway as bridge to get the on-premises data source.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem
So you'd better keep the Computer is always on to keeo the gateway is online.
In effect dataflows are an online data collection and storage tool.
Then use power bi desktop to get data to import it and use it create a dataset.
https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview
https://radacad.com/what-are-the-use-cases-of-dataflow-for-you-in-power-bi
Wish it is helpful for you!
Best Regards
Lucien
Hi Lucien
Thank you for your reply, but the dataflow is working and refreshing fine.
I have many dataflows set up and they run fine in the service.
This seems to be a bug or something undocumented where the dataflow seems to have a "memory" for something that no longer exists.
I might play around with the JSON export and see if I can fine tune it.
Cheers
Ollie
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.