cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OliverO
Helper I
Helper I

Power BI Dataflow not configured correctly - phantom files - add to gateway

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

 

data flow error.PNG

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

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.

  • Collection:  It uses Power Query to connect to the data at the source and transform that data as needed.
    • You will need to be able to access the data either through a cloud service (such as Dynamics 365) or to your PC/Network via a gateway.
    • You can also use Power Query to write queries from scratch, such as my Power BI calendar table.
  • Storage:  Dataflows then stores that data in a table in the cloud so it can be used directly inside PowerBI.com, but more importantly (from my view) directly from Power BI Desktop.

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.