Problem when refresh query

[vinicius_ramos]

Hello, 

I need a help, when I refresh the query this message appears: Query 'Base Dashboard' (step 'Filtered Rows9') references other queries or steps, so you cannot have direct access to a data source. Recompile this data combination.

How can I resolve this, anybody can help me? 

Thanks

[v-jingzhan-msft]

Hi @vinicius_ramos 

You may refer to the solutions from following links:

Query references other queries or steps, so it may... - Microsoft Fabric Community

Power Query Errors: Please Rebuild This Data Combination (excelguru.ca)

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[vinicius_ramos]

Hi, doesn't work. 

The same problem continuous happend;.

[lbendlin]

Do as the error message suggests. Refactor your queries to avoid merges and referencing.

[vinicius_ramos]

Hi, @lbendlin 

How do I refactor my queries? I don't understand, could you explain it to me in a little more detail?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...