Power BI列映射不显示值问题求助

Hey Tintu, let's work through why you're not seeing your DOMINO_API_KEY value after converting your JSON to a table in Power BI. Here are the most common fixes and checks to try:

1. Verify Your Power Query Transformation Steps #

Your single key-value pair JSON ({ "DOMINO_API_KEY": "val1" }) loads as a record first in Power Query, not a table. If you skipped expanding this record, you won't see the value in your final table. Here's how to fix it:

• Open the Power Query Editor (go to Home > Transform Data).
• Look at the Applied Steps pane on the right:
  • After the Source and JSON steps, you should see a To Table step that converts the record into a single-row table (with one column containing the record).
  • Next, click the expand icon (two outward arrows) on the header of that single column. Select DOMINO_API_KEY from the dropdown, and click OK. You should now see a column with your val1 value.
• Click Close & Apply to save these changes and load the data into your Power BI model.

2. Check if You're Loading Data to the Model #

If you stopped at the transformation step without clicking Close & Apply, your data won't be available in the main Power BI interface. Make sure you've committed the changes so the table with your value is visible in the Fields pane.

3. Validate Your Mapping Table Setup #

When creating your mapping table:

• Ensure you're selecting the transformed table (the one with the expanded DOMINO_API_KEY value) as your source.
• Double-check that you're mapping the correct column (DOMINO_API_KEY) to your target fields in the mapping table. Sometimes it's easy to miss selecting the column if it's not highlighted properly.

4. Quick Check for File/Encoding Issues #

While less likely since you could convert to a table, confirm your JSON file is saved in UTF-8 encoding (most text editors let you check this when saving). Non-standard encodings can sometimes cause unexpected behavior in Power BI.

If you walk through these steps, you should be able to see your val1 value in your mapping table. Let me know if you hit any snags along the way!

内容的提问来源于stack exchange，提问作者Hound