Forum Discussion
Dataflows not available in Get Data
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!
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.
7 Replies
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.
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-bitApril 2024 version of Power BI Desktop - 64-bit
Best Regards,
Gao
Community Support TeamIf 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
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.
Hi -Try the following steps:
- 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!!
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!!
- clear cache of your desktop:
