Dataflows not available in Get Data

[MilliePowerBI]

Hello all, 

I have recently been issued with a new work laptop (yesterday). When I open Power BI and go Get Data, Dataflows appears on the list, but when I click it, nothing happens. 

If I go More... and go to Microsoft Fabric, I also do not see it among the options

If I search Dataflow, I only see the Legacy variation, which isnt what I need. 

I still have my old work latop, and when I open Power BI there, I can see dataflows, so its not an issue (I dont believe) with my account having access to dataflows or anything. I have created and am the owner of loads of dataflows in Power BI Service. 

It only seems to be an issue with Power BI, I can access Dataflows through excel, I can access and create dataflows in Power BI Service etc. 

I am currently using, what I believe to be the most up to date version

Can someone please give me some advice? Is there something I need to activate somewhere in Power BI desktop? This is a fairly ciritcal issue for me, as I have several reports connecting to dataflows, which I cant refresh because it doesnt seem to recognise the dataflow

Please, any advice would be wonderful! 

Thank you!

[MilliePowerBI · Accepted solution]

@rajendraongole1 @Anonymous 

Thanks for your help, but I think I have this one solved. 

For anyone else who may be reading along, or one days finds this thread - what turned out to be the issue here for me was; 

There is a Programs Files folder 

C:\Users\USERNAME\Microsoft\Power BI Desktop Store App\CertifiedExtensions

on my new laptop, this was completely empty. On my old laptop, this had 112 .pxq files, one of which was "PowerPlatformDataflows.pqx"

I copied all the files from this folder on my old laptop and pasted them into the empty folder on the new laptop, closed Power BI, rebooted the computer and now everything works as normal. 

Why this folder remained empty throughout multiple uninstall/reinstalls and roll backs to previous versions, I cant answer. I dont know why this was the case. But once I copied everything over - BOOM - back in business. 

Hopefully this helps someone else in the future. 

Thanks again to @rajendraongole1 & @Anonymous  for their help up to this point. 

[rajendraongole1]

Hi  -Try the following steps:

1. clear cache of your desktop:

   Turn to menu bar-> click“file”-> “options and settings”->”options”, then under “global ”->”data load”, find “clear cache”:

    2.Then turn to the menu bar,  click “Home”->”edit queries’’->”data source settings”, then find “Global Permissions”->”clear permissions”：

   3.Finally “Get Data” from “Power BI datasets”, you will find a “sign in ”window->”Sign in”:

   
   

     

   Hope this time would help.

   Did I answer your question? Mark my post as a solution! This will help others on the forum!
   Appreciate your Kudos!!

   

   

@MilliePowerBI

[MilliePowerBI]

@rajendraongole1 

Thank you for your efforts, but I followed these steps and the same issue persists. 

[rajendraongole1]

Hi @MilliePowerBI - as suggested by @Anonymous - can you try to rollback to old versions. if it is required to use dataflow

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[MilliePowerBI]

@rajendraongole1 & @Anonymous 

Hey thanks again for your efforts to this point. 

I have uninstalled June 2024 and rolled back to both April and May 2024

Same issue on both#

I think I might get IT to wipe and reinstall my new laptop. Its only two days old at this point, maybe nuking the site from orbit is the only way to go! 

Do you guys have any other ideas?

[Anonymous]

Hi @MilliePowerBI ,

Could you find the Dataflow connector in the PowerQuery Editor?🤔

1. Try clearing the cache. 'File' menu -> 'Options and settings' -> 'Options' -> 'Data Load' and then clearing the cache.
2. There might be an issue with your current installation. Try uninstalling and then reinstalling Power BI Desktop on your new laptop.

Download Microsoft Power BI Desktop from Official Microsoft Download Center [6333-e183-472-f54d]

If this issue is affecting your work, please temporarily roll back to the May or April version of Power BI Desktop, which is available for download at the link below.
May 2024 version of Power BI Desktop - 64-bit 

April 2024 version of Power BI Desktop - 64-bit 

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[MilliePowerBI]

@Anonymous 

"Could you find the Dataflow connector in the PowerQuery Editor?"

No, I cannot. If I go to PowerQuery Editor and then New Source it is the same

I also notice that Microsoft Fabric is missing from this view altogether. 

"There might be an issue with your current installation. Try uninstalling and then reinstalling Power BI Desktop on your new laptop."

I have tried this 3 or 4 times now. Same results. 

I have also just rolled back to May 2024 and the same thing is occuring. Will try April and let you know.