Power BI can't load tabel data, which is showed preview(Power Query)

2025-06-09T06:39:25.6166667+00:00

I am trying to retrieve data where the part codes in the parts master match the part codes specified arbitrarily by the user. However, although the data is correctly output in the preview, the expected data is not present in the table.

I have taken the following measures, but the issue remains unresolved:

  • Cleared the cache
  • Matched the data types of the columns in the parts master
  • Removed filters from the sheet

In the parameter management, the following settings are selected:

  • Text type, list of values

Process details:
First, I obtain a list of values specified by the parameter, and then I loop through this list to filter the data by matching the values in the same column of the original table.

Thanks from Japan.

Preview : 2 records are shown in the preview table.

User's image

Table : No data.(Same 2 records should be shown in the table.)User's image

Community Center | Not monitored
0 comments No comments
{count} votes

Accepted answer
  1. simo-k 10,655 Reputation points Volunteer Moderator
    2025-06-09T07:48:35.61+00:00

    Microsoft Q&A(en-us) does not support Fabric.
    Please ask your question in the community below.
    Fabric Community
     ├ Power BI
     ├ Data Engineering
     ├ Data Warehouse
     ├ Data Science
     ├ Data Factory
     ├ Real-Time Intelligence
     ├ Databases
     └ Fabric platform

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.