Dataflow tables not appearing in the desktop

[bpetrillo153]

Hi, we have some a few dataflows that we use in our data model that are no longer showing up in the pbix desktop. They appear in the service, but you cannot connect to them any longer. Any one have any ideas of what is going on? 

I have see posts about changing the field type to datetime, but its already set to that and still no luck. We have other dataflows connected to the same database that appear, but the queries are a lot less complex. 

Any help is appreciated! 

[v-mengzhu-msft · Accepted solution]

Hi @bpetrillo153 ,

It may be because other account used to obtain dataflow data in Power BI Desktop before, and PBD remember and saved the this "other" account. Please clear the permission of this account and sign in with the current account. 

1. Click Files –> “Options and settings” – “Data source settings”, then find “Power BI Dataflows” in “Global Permission” to clear Permission.

2. Get data--> Power BI dataflows--> Sign in

At the same time, hope the following post with similar issue as yours can help you:

Solved: Just started this week - DATAFLOW table does not s... - Page 2 - Microsoft Power BI Communit...

Solved: Dataflow - No table show up in Desktop - Microsoft Power BI Community

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[aj1973]

Hi @bpetrillo153 

You need to be granted access to the Dataflows in the service. Ask Power Platform Administrator.