Write DAX Query in Service Fails with Power Query Function Generated Table

[Martin_D]

Hi,
I'm using the attached pbix file. I upload the file to a workspace. There, I want to query the semantic model using "Write DAX Query". I have semantic models where this works, but with this model, it shows error like below. The file is attached. The data source credential are "Anonymus" login type, so you can reproduce it.

The semantic model refreshes in the Power BI service without error, and there are also no unsued expressions in Power Query that the refresh might not look at but the Write DAX Queries features. I can also create reports (which then successfully query the semantic model, technically) without problems.

Why does Write DAX Queries fail? What do I need to change so that it does not fail (without changing the result)?

Thank you very much!
Kind regards,
Martin

[v-ssriganesh]

Hi @Martin_D,

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

Thank you.

[Martin_D]

Hi @v-ssriganesh ,

No it's not solved. Seems to be a bug in Power BI Service since the same bug does not exist in Power BI Desktop.

Kind regards,

Martin

[v-ssriganesh]

Hello @Martin_D,
If these solutions do not resolve the issue, please consider raising a Microsoft support ticket. You can create a Microsoft support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this helps, kindly Accept it as a solution and give a "Kudos" so other members can find it more easily.

Thank you.

[v-ssriganesh]

Hi @Martin_D,
Could you please confirm if this issue has been resolved? If it has, kindly mark it as the solution and share the details in the community to help other members.
Thank you.

[Martin_D]

Hi @v-ssriganesh ,

No it's not solved. Seems to be a bug in Power BI Service since the same bug does not exist in Power BI Desktop.

 Using the file attached to the original post you can verify yourself whether it is solved.

Kind regards,

Martin

[v-ssriganesh · Accepted solution]

Hi @Martin_D,

Thanks for getting back and sharing the update. I understand that the issue persists in Power BI Service but not in Power BI Desktop. Since this might be a potential bug, we recommend raising a Microsoft support ticket for further investigation.

In my previous response, I shared the link how to create a support ticket. If you haven’t already, please raise a support ticket:
Create a Microsoft Support Ticket

Once you've raised the ticket, please share any updates in the community. This will assist others who might be experiencing the same issue. If this is helpful, kindly accept it as a solution and leave a "Kudos".

[v-ssriganesh]

Hello @Martin_D,
Could you please confirm whether the issue has been resolved after raising your support case? If a solution has been found, we would greatly appreciate it if you could share your insights with the community. This would be valuable for other members who may encounter similar issues.

As of now, we are closing this case. If you have any further questions, feel free to reach out to the community by creating a new post, and we’ll be happy to assist you.

Thank you for continuing to use the Microsoft Fabric Community Forum.

[v-ssriganesh]

Hi @Martin_D,
Thanks for posting your query in microsoft fabric community forum.

Since this is a data model circular dependency issue on your side, I notice there are many columns, making it challenging to identify the root cause. Similarly, you can use Power BI Desktop DAX Query Editor.

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[Martin_D]

Thank you, @v-ssriganesh for looking into this.

This is exactly my concern: In Power BI Desktop query view it works. That's why I don't think it's a problem on my side. It must be some problem with Power BI service. But not all users that have build permission and want to query data in the web browser have privilege to download the file. And we also don't want grant this privilege to everyone. We need a solution that works in the web browser. We have this problem with many semantic models. That's just an isolation that I can share publicly.

Kind regards,

Martin

[v-ssriganesh]

Hi @Martin_D,

There are some considerations and limitation while using  ‘Write DAX query feature’, Please refer this documentation and make sure you are meeting all the requirements.
https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view#considerations-and-limitat...

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[Martin_D]

Hi @v-ssriganesh ,

Thank you for sharing the constraints. Although there are interesting constraints regarding other planned activities, specifically Git integration, there is no limitation that applies to or explains my situation.

Kind regards,

Martin

[v-ssriganesh]

Hi @Martin_D,

The error "Circular query chain present" indicates that your dataset contains a reference loop, specifically involving the fnCreateDateTable function. This issue arises when a query references another table that, in turn, depends on it, creating a cycle.

To resolve this, you should ensure that fnCreateDateTable does not depend on any tables that reference it. If you're using a dataset to determine the date range, you might want to consider using static parameters instead. This approach can help break the cycle and prevent the reference loop.

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[Martin_D]

Hi @v-ssriganesh ,

Since this error does not exist in Power BI Desktop I cannot debug it in Power BI Desktop. Since there is no Power Query editor for the semantic model in the web browser I cannot degug this in the web browser.

Could you please provide a minimalistic Power Query example that works in Power BI Desktop but shows this error in the web browser to help me understand the pattern that I need to look for in my Power Query code?

Thank you very much!

Kind regards,

Martin

[v-ssriganesh]

Hi @Martin_D,

Hope you are doing well, 

Thanks you bringing your concerns with us and below is the breakdown for your concern.

Some Power Query functions that work in Power BI Desktop are unsupported or behave differently in the Power BI Service. 
Similarly, I encountered an issue with a custom visual, but not with Power Query. In Power BI Desktop, the custom visual works fine, but its behavior is completely different when used in the service.

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.