Circular query error, can't open Data Model in Service

[lf2606]

Hello, 

I made a report that relies on API data that is refreshed daily for a certain report. 

I wanted to edit the data model so I can add a new table, but whenever I try to open the data model in the service, I get the following error: 

I am unable to see the query for that specific table so I could edit the query and fix the problem. 

The data is refreshed successfully every day without any issue and this error didn't show up when I built the report on Desktop. 

How can I fix the query so I can edit the data model ?

[v-tianyich-msft · Accepted solution]

Hi @lf2606 ,

This can happen due to the way the relationship is set up or through complex calculations of columns or measure values. And the official documentation suggests it:Enabling the edit data models in the Power BI service preview doesn't apply to editing a semantic model through an API or an XMLA endpoint.

Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Do you still have the option to download the pbix?