topic Re: PowerBI dataset refresh error in Service

PowerBI dataset refresh error

yrraggy — Tue, 10 Nov 2020 22:54:44 GMT

Im getting a PowerBI refresh error on PowerBI website. Majority of the PowerBI has this error and it is an error that i never encountered before.

Underlying error code: -2147467259 Underlying error message: The import List.ConformToPageReader matches no exports. Did you miss a module reference? DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.Reason: Expression.Error Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net Activity ID: 43fb3ee1-463b-4f8c-995d-d7b95086b757 Request ID: cb435964-a8ff-434e-9efe-76220aaf3090 Time: 2020-11-10 18:31:15Z

May i know if there is an existing bug on the Powerbi website?

Re: PowerBI dataset refresh error

gaveer_mfst — Wed, 11 Nov 2020 03:13:32 GMT

yrraggy were you able to reslove the issue?

Im also facing similar issue and reprot refresh are failing, there was no change in Reprots, DB and Gateway. I tried looking for help or documentation and wasn't able to find any.

Looks like it would be a power query issue from below article

https://docs.microsoft.com/en-us/powerquery-m/list-conformtopagereader

Below is the error message.

Underlying error code-2147467259
Underlying error messageThe import List.ConformToPageReader matches no exports. Did you miss a module reference?
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.ValueError.ReasonExpression.Error
Cluster URIDF-MSIT-SCUS-redirect.analysis.windows.net
Activity IDbe15849b-4567-4324-82d6-e50549fbb0cc
Request ID80d46535-4ceb-bf99-c562-f6c50bef0e81
Time2020-11-11 02:07:37Z

Thanks.

Re: PowerBI dataset refresh error

MSHUANXU — Wed, 11 Nov 2020 04:57:21 GMT

I'm also facing this issue, and I can refresh locally. In fact, I did nothing to the report.

Underlying error code:	-2147467259
Underlying error message:	The import List.ConformToPageReader matches no exports. Did you miss a module reference?
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	Expression.Error
Cluster URI:	DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:	c9113975-cdca-4048-8a55-c34164156656
Request ID:	00c9fa47-f343-4c02-a93f-da5f2107577d
Time:	2020-11-10 23:05:22Z

Re: PowerBI dataset refresh error

JustGotLucky — Wed, 11 Nov 2020 08:35:49 GMT

I am also facing the same issue and I can refresh the pbix file locally. Does anyone have any detailed documentation on the List.ConformToPageReader method?

Re: PowerBI dataset refresh error

anujgup — Wed, 11 Nov 2020 16:52:03 GMT

I am also facing simpler issue for all the my gateway based reports.

Re: PowerBI dataset refresh error

JUPERD — Wed, 11 Nov 2020 17:12:44 GMT

Same issue here.

I tried to update the gateway.
It didn't change anything.

Re: PowerBI dataset refresh error

evang550 — Wed, 11 Nov 2020 22:18:49 GMT

I'm also having this issue. Impacting all my scheduled refreshes. Anyone able to resolve or know if the issue has been reported?

Re: PowerBI dataset refresh error

sbg94 — Thu, 12 Nov 2020 06:19:48 GMT

We faced same issue, It got resloved by installing latest version of gateway.

Re: PowerBI dataset refresh error

anujgup — Thu, 12 Nov 2020 17:12:43 GMT

Error can be resolved by installing latest version of gateway.

Re: PowerBI dataset refresh error

chuckwheelis — Thu, 19 Nov 2020 12:56:52 GMT

Had the exact same problem. Lots of managers with blank reports this morning. Microsoft has our email addresses right? Maybe you could let us know if we need to prepare for things like this???

Re: PowerBI dataset refresh error

hamelj — Thu, 19 Nov 2020 13:25:24 GMT

We have the exact same problem although it started for 1 dataset. Now it is ha^ppening to all.

Re: PowerBI dataset refresh error

lgroger — Thu, 19 Nov 2020 14:47:08 GMT

We just started having this issue overnight also for about 5 datasets but about 15 others worked fine. I just manually refreshed one that was successful overnight and it still runs but the 5 that errored are all now erroring immediately. No changes to any reports/datasets have been made in at least a week. I know we do need to upgrade our gateway eventually but that's going to be a process b/c the original person who installed it is no longer with the company and didn't record their recovery key. It just doesn't seem to make sense that some datasets work (and direct queries) and some dataset refreshes do not. I can refresh using Power BI desktop also without any issues.

Re: PowerBI dataset refresh error

Anonymous — Thu, 19 Nov 2020 16:52:47 GMT

We are experiencing the same issue. Zero changes made, but we are having a refresh failure.

Re: PowerBI dataset refresh error

mukeshpatel — Thu, 19 Nov 2020 17:21:52 GMT

I am experiencing the same issue.

Cluster URI: WABI-US-NORTH-CENTRAL-F-PRIMARY-redirect.analysis.windows.net
Activity ID: e85ef16a-03c8-4688-beeb-f9a3a002a07f
Request ID: 78bf4fe8-1ece-48c8-b771-b8988cda82a6
Time: 2020-11-19 17:03:12Z

Re: PowerBI dataset refresh error

GeovanniEco — Thu, 19 Nov 2020 17:41:25 GMT

I have the same error, has anyone already found the solution?

Re: PowerBI dataset refresh error

JUPERD — Thu, 19 Nov 2020 17:44:20 GMT

Update your Gateway with the latest version on your VM.

Re: PowerBI dataset refresh error

Anonymous — Thu, 19 Nov 2020 19:27:09 GMT

Updated Gateway and everything is good to go! Thank you!

Re: PowerBI dataset refresh error

Anonymous — Thu, 19 Nov 2020 20:12:54 GMT

Juperd,

I am getting this exact same error. We have updated our server gateway to the Nov. 2020 release and I updated the personal gateway on my machine, However my refreshes are still failing. Am i missing something?

if there is a rogue personal gateway somewhere that is out of date, would it matter?

Thanks

Re: PowerBI dataset refresh error

Anonymous — Thu, 19 Nov 2020 20:39:04 GMT

I'm also having the same problem:

Re: PowerBI dataset refresh error

smodglin — Fri, 20 Nov 2020 14:46:36 GMT

We are having the same issue. I updated the Gateway but continue to have same refresh issue. Is there anything else to try?