Error when saving report - PowerBI Desktop

[guiggs]

Hello all,

I have DirectQuerys to all my tables in PowerBI. But I have to filter one of the tables of my SQL Server and I'm doing the following formula:

But after doing this, I try to save it and I get the following error:

Do you have a solution? 

Thanks

[v-xicai]

Hi guiggs ,

I have reported this issue internally, will update here once I get any information.

Best Regards,

Amy

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

[guiggs]

Hi Amy,

Thank you for the update. Yesterday I had a call with the support team but unfortunatelly we hadn't find a solution. 

Once I have to proceed with my work, I found a solution making a SQL statement when doing a DirectQuery to the data table.

If you have an update please let me know.

Thanks,

Guilherme

[brianhartman · Accepted solution]

Thank you for reporting this issue.  We have identified and fixed a bug in the product that was causing it.  The fix will ship with the May release of Power BI Desktop.

[guiggs]

Hi @brianhartman!

Thank your for the information!

I'm glad that I helped improving your software.

Do you have some kind of reward or some job offer right there? ehehehe

Thank you!