Issues

Under Review

Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Vote (14)

Gabrielius on 18 Jan 2017 22:31:18

Locally datasources refresh well, yet getting this error when trying to refresh dataset in PowerBI.

There was an error when processing the data in the dataset.
Data source type:
Processing error: The import Percentage.Type matches no exports. Did you miss a module reference?

Screenshot: https://snag.gy/fMVWza.jpg

Someone experiencing it as well:
https://community.powerbi.com/t5/Integrations-with-Files-and/The-import-Percentage-Type-matches-no-exports-Did-you-miss-a/td-p/97358

Comments (13)

Comments (13)

Richard Kennedy on 05 Jul 2020 22:39:17

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Thanks Mark Zikra, I couldnt find any more %types in my queries but this showed that filtered rows after the data type were changed were causing the issue. For anyone else If you delete these percentage.type rows and then have errors which cause the query to not display simply click find error (at the top on the error message). Mine were filtered rows which I deleted and then refiltered

Mark Zikra on 05 Jul 2020 22:39:14

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

While Microsoft works on the issue, I have found a workaround that allows for Web interface scheduled refresh and manually refresh so you dont have to constantly publish your data set.

If you converted the data to percentage type, remove that "Changed Type" from your applied steps. you can also find in the advanced editor (right click on your querie and click Advanced Editor) with anything labled as "percentage.type" Example:

#"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns2",{{"Current Occupancy", Percentage.Type}, {"16 - 17 Opening Occ", Percentage.Type}}),

^^Delete all of those references

Once you remove all of those, leave the data as a decimal and create a calculated measure to produce the percentage. This way, it does not find that Percentage.Type error upon refresh and works just fine.

Not a permanent solution, but a resolution to a crippling refresh issue...

Power BI User on 05 Jul 2020 22:39:13

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Any update on this issue? Our PROD environment refresh fails due to this issue.

Heather on 05 Jul 2020 22:39:13

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Same issue here

PZL IT Team on 05 Jul 2020 22:38:48

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

The problem is still not resolved to this day!
MS: "Also, with your permission I will kindly ask you if it's ok to archive the case as all we can do is wait for the back office engineers to fix it. I don't have a specific time frame for this, but it was already escalated to the proper team for a fix"

Power BI User on 05 Jul 2020 22:38:42

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Same here... Thanks!

sadf sdf on 05 Jul 2020 22:38:39

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Have asked the team to look into it

Stefanos Zervos on 05 Jul 2020 22:38:38

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Same here

Timothy Conroy on 05 Jul 2020 22:38:38

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

Same here

Abayomi Elebute on 05 Jul 2020 22:38:34

RE: Failing Dataset refresh - "The import Percentage.Type matches no exports. Did you miss a module reference?"

I am facing this problem as well. Please help fix this bug.