Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Hi @Nishantjain
It seems an issue with report server.I would suggest you go to Report Server forum to post this thread.
Regards,
Don't think it is report server as this is for the Power BI Paginated Report builder
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |