I've filtered the OData URlL but when I import it in Power BI it shows other columns as well

[MalikSalman]

You guys can see this in the image below. 

Kindly let me know if there is a way I don't get the other columns.

[Anonymous]

Hi @MalikSalman,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Hi @MalikSalman,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[Anonymous]

Hi @MalikSalman,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help?

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[Anonymous]

Hi @MalikSalman,

Thanks for reaching out to the Microsoft fabric community forum.

As the issue has been addressed by @FarhanJeelani, please accept is as the solution if it works for your question. 

Also go through the attached link to get proper understanding of how Schema of different Data sources works.

Handling schema for Power Query connectors - Power Query | Microsoft Learn

If this post helps, then please consider Accept it as the solution and give a Kudos to help the other members find it more quickly. If you have any other queries, feel free to reach out to community forum for assistance.

Thank you. 

[FarhanJeelani · Accepted solution]

Hi @MalikSalman ,

It looks like you’ve tried to filter the columns in the OData feed URL by specifying the select parameter, but Power BI is still pulling in additional columns. This issue can happen for a few reasons:

Possible Solutions:

1. Ensure Proper Use of $select in OData Query:

   • Verify the OData URL you are using. The $select parameter should explicitly specify the columns you want to import. For example:

     https://cloud.data.com/api/v1/account?$select=account_id,account_label,amount_usd,amount_currency

     If $select is correctly applied, only the specified columns should load.

2. Preview Mode Limitation:

   • Sometimes, Power BI might still display additional columns in the preview. After applying transformations or loading the data, these columns might not appear in the actual dataset.

3. Apply Column Selection in Power Query:

   • If the OData feed returns extra columns regardless of the $select parameter, you can remove them manually in Power Query:
     • Go to the Power Query Editor.
     • Select the unwanted columns and click Remove Columns.
     • Apply and close.

4. Query Folding Issues:

   • If Power BI doesn’t recognize the $select parameter due to query folding, ensure the data source supports this functionality and that the OData feed URL is correctly formatted.

5. Check for Errors in OData URL:

   • Look for typos or issues in your URL syntax.
   • Make sure the selected columns are valid fields in your data source.

6. Custom Function in Power Query:

   • If filtering via the URL doesn’t work, you can use a Power Query M function to extract only the columns you need:

     Table.SelectColumns(Source, {"account_id", "account_label", "amount_usd", "amount_currency"})

Verify:

In the image, it seems that other columns are displayed as errors. If the issue persists after trying the above steps, the problem might also be with the data source or the OData feed configuration. Let me know if you need further clarification or help with any of the steps!

Please mark this as solution if it helps. Appreciate Kudos.