We have several reports hit the follwing errors since Nov 10. It shall be introduced by a server side change. The report were not changed.
Underlying error code: -2147467259
Underlying error message: The import List.ConformToPageReader matches no exports. Did you miss a module reference?
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: cbe4a951-b23b-4a14-b58e-a0d5f890a7e5
Request ID: 01ae5afd-d8bd-14ba-09b9-acd08961f701
Time: 2020-11-13 15:33:56Z
Solved! Go to Solution.
@karlk - new gateways are relased every month, usually within a week or so of the Power BI Desktop. Lots of under-the-hood fixes I'm sure, but it also keeps the mashup engine on par with Power Query in the Power BI Desktop. There was another breakage this past summer if you used the "Add Index Column" feature in Power BI but your gateway was more than 3 months out of date. Upgrading the gateway fixed it.
I am not advocating you upgrade the day a new gateway is released, but it should be something you do every month. New Power BI Desktop - just make a note in 14 days or so, go get the latest Gateway to ensure you stay up to date.
And FWIW, I saw a tenant go down today as all reports that used the gateway went down over the weekend. Upgrading the gateway to Nov 2020 fixed it.
Same problem here. The issue didn't affect reports that used DirectQuery to connect to a database through the gateway though.
I understand that my gateway was out of date and installing the latest version resolved the issue. However, I shouldn't have to find out by my refreshes working one day then breaking the next.
Is there a recommendation on how up to date you should keep your gateway, please? I've read the blogs and there's nothing I can find anything that would indicate refreshes may break unless I'm missing something.
Any pointers would be appreciated as I want to avoid this in the future.
I agree with @karlk ,
There should be a communication channel to inform us ahead that an update is required. I am not the system administrator and will check with them if they received anything of their side, but finding out a Monday morning that reports in production are not refreshed since Saturday is to say the least, annoying. 😉
Updating to the latest version of the gateway solved the problem. 👍
Moving forward is this liable to happen again i.e. forcing a gateway update? Automatic update? 🤔
I had a number of reports fail this morning. We were running the August version Gateway, just updated to November and it looks like I'm now able to refresh again.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.