topic Dataflow Generation 2 - Problem with refreshing in Developer

Dataflow Generation 2 - Problem with refreshing

SisterRay — Fri, 30 Jun 2023 12:46:56 GMT

Hi all,

I've noticed that if there are any functions in query (for example, fnExpandAllRecords) the data flow won't be refreshed and also very often re-publishing/publishing will be not successful. What could be the reason for that?

Refresh history:
Dataflow 8,Failed,NA,2023-06-30T10:32:05.187+00:00,2023-06-30T10:32:19.843+00:00,00:00:14,NA,Failed,There was a problem refreshing the dataflow. Please try again later. (Request ID: b99b783f-3571-4891-a377-a9e7f59f0f51).

Function:
https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

Re: Dataflow Generation 2 - Problem with refreshing

Anonymous — Mon, 03 Jul 2023 07:55:25 GMT

Hi @SisterRay ,

According to your provided info, I get something from the backend. Hope it can give you some insights or clue...

App-only AAD authorization did not succeed.

In addition, you can review the following links to expand the columns.

Expand All Columns Dynamically in Power Query - Goodly

Solved: Re: Append Queries expand column not showing for f... - Microsoft Fabric Community

Handle errors:

excel - Handling errors when expanding table in power query - Stack Overflow

Best Regards