Report Builder - Unable to use my own Dax query (instead of designer view)

[Nishantjain]

Hi, 

I am trying to build a report using the dataset in Power BI service. If I create the report using the designer mode, it works fine. 

When I try to create the same query using the "Text Mode", it gives me an error. However, the preview works fine. 

Preview in text mode works fineError message

Also, when I try to move the design mode to text mode and go back again to the design mode, it give an error.

Below is the error message 

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.ChangeMode()
at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderControl.MDXDelegate.ChangeDesignMode()
at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderControl.OnMenuQueryBuilderDesignMode(MenuCommand menuCommand, CommandHandlingArgs args)
at Microsoft.DataWarehouse.Design.CommandHandlingInfoMap.HandleCommand(MenuCommand menuCommand)
at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderControl.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.MenuServiceForModalForms.MenuServiceImpl.InvokeCommand(CommandID commandID)
at Microsoft.DataWarehouse.Controls.VsStyleToolBar.OnButtonClick(ToolBarButtonClickEventArgs e)
at System.Windows.Forms.ToolBar.WmReflectCommand(Message& m)
at System.Windows.Forms.ToolBar.WndProc(Message& m)
at Microsoft.DataWarehouse.Controls.VsStyleToolBar.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

//truncated

Thanks

[v-cherch-msft]

Hi @Nishantjain 

It seems an issue with report server.I would suggest you go to Report Server forum to post this thread.

Regards,

[Nishantjain]

Don't think it is report server as this is for the Power BI Paginated Report builder

Power BI Paginated report builder