Skip to main content

    Issues

    Under Review

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

    Vote (14) Share
    Gabrielius's profile image

    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)
    Gabrielius's profile image Profile Picture

    bd1058e9 93a1-4726-af0f-9658ce93f4e0 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

    Gabrielius's profile image Profile Picture

    73234dbe 8342-42ab-8ed2-392039655964 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...

    Gabrielius's profile image Profile Picture

    a90b4c98 a292-4e5e-a90d-d9426162e006 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.

    Gabrielius's profile image Profile Picture

    ee411156 8072-4b9f-9db6-ff268989681c 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

    Gabrielius's profile image Profile Picture

    874b079c 067d-42a4-ac16-ed4634d87faf 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"

    Gabrielius's profile image Profile Picture

    53661bd2 d322-4958-84c2-8934f72d1046 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!

    Gabrielius's profile image Profile Picture

    ac643e7c e800-ea11-a811-000d3a4f1ebb 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

    Gabrielius's profile image Profile Picture

    4ddc5641 9bc4-4072-8abb-15122d847334 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

    Gabrielius's profile image Profile Picture

    c4fe8479 69b7-4c74-bf9d-4e1576542a4b 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

    Gabrielius's profile image Profile Picture

    bf123f49 fa36-4dac-be70-5e677a46c7d8 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.