Powerbi Dataflows not showing on Desktop

[Anonymous]

Hi,

Im having some troubles with the PowerBI service dataflows. I've been working on a dashboard for some time now which gets all its data from the dataflows. When i started working this morning the refresh suddenly didn't work anymore on desktop, while on powerbi service the data is still correctly getting refreshed. I think my powerbi desktop has some sort of disconnect with the powerbi service platform, because when I went to add another data source suddenly I couldn't access my own workspaces anymore, while when in in PowerBI service everything still works as intendended. Does anyone have any ideas on how to solve this?

[Anonymous]

Hi, @Anonymous 

Thanks for Expiscornovus's reply. You can refer to his suggestion, you can try to clear the permission of the account and relogin.
Steps: Click Files –> “Options and settings” – “Data source settings”, then find “Power BI Dataflows” in “Global Permission” to clear Permission.

Or you can roll back the version of Power BI Desktop to September and try to connect again.
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

If it still does not work. Given can't reproduce your problem at this time, I can't tell what's causing your problem.You can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Thank you for your understanding.

Best Regards,
Yang
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

[Anonymous · Accepted solution]

I solved it this morning! By turning the code PowerBI uses to connect to regular dataflows into code that connects to the legacy dataflows. Since PowerBI suddenly only recognized my dataflows as legacy dataflows, this worked.

This is the code I changed:

This is the code that used to work before my dataflows were seen as legacy dataflows:

This is the code that makes it work at the moment

Thanks @Expiscornovus and @Anonymous for the replies!

[Anonymous]

Hey @Expiscornovus, when I try to publish a new report, suddenly the workspaces do appear, but when I want to select a dataflow, I still cant see any workspaces. Clearing the cache also didn't resolve anything

This is what i see when trying to select a dataflow

And this is what I see when I want to publish to a workspace:

This leads me to believe PowerBI can see the workspaces, but doesn't recognise the dataflows inside the workspace as dataflows. To test this I created a simple new dataflow in another workspace.

This dataflow still doesnt load inside the navigator when trying to access the dataflows.

[Expiscornovus]

That is strange, also because the navigator does show 2 dataflows in total as a count in the top of the tree view.

Have you tried looking in the diagnostic/traces files? That might give you some clues.

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-diagnostics

[Anonymous]

Hey @Expiscornovus, 

I just discovered something else that might clear some things up, all dataflows that used to work as normal dataflows, can now only be found in the Power BI dataflows (legacy) options, could that be causing my problems? I have no idea why they are suddenly classified as legacy dataflows.

[Expiscornovus]

Not sure if that is the reason. I also have dataflows which are not Gen2 showing up in that Navigator. Below is an example of a dataflow which I created two years ago.

Btw, did you manage to check your diagnostics/trace log? Alternatively, I might be good to contact Microsoft support about this as well?

[Expiscornovus]

Hi @Anonymous,

Just to double check, are you still signed into Power BI Desktop via your account? (right top corner). Maybe it is worth signing out and back in again. Would be a simple way of check if it is a disconnect.

Out of interest, which version of Power BI Desktop are you running? Are you running the October 2024 release?

[Anonymous]

Hi @Expiscornovus,

Thanks for your reply, but unfortunately signing out and back in did not work. I'm running Powerbi on the latest version.

[Expiscornovus]

Have you tried publishing a new simple report via the Publish option as a test? When you try that does it actually list your workspaces? Just to double check if it can find your workspaces via Power BI Desktop.

Maybe it is related to cache? Power BI also has cache settings as well.