Forum Discussion
PowerBI RB, Data not outputting when Running
- Hello v-ssriganesh
Very much appreciate your message, thank you!Unfortunately, I have just managed to fix my issue and am about to close this case ... Turns out within the database I am using, there exists multiple "Bill2" and "Ship2" fields, I was simply using the wrong, unused feilds by mistake :') Hello Avery001,
Thank you for the update. I’m glad to hear you were able to resolve the issue—it’s great that you identified the mix-up with the "Bill2" and "Ship2" fields in your database. These kinds of mistakes can happen, especially when working with databases that have similar field names.
Since the issue is resolved, please mark it “Accept a solution”, as it might help others in the community who encounter a similar issue. Thanks again for sharing your solution.
Best regards,
v-ssriganesh
Community SupportHello Avery001,
Thank you for reaching out to the Microsoft Fabric Forum Community.
After thoroughly reviewing the details you provided, Here are a few steps to help troubleshoot and resolve the issue:
- Ensure the datasets for the Ship To and Bill To tables aren’t overly restricted by the parameter. In the Dataset Properties (right-click the dataset > Dataset Properties > Filters tab), verify that the parameter filter (likely tied to order_no) aligns with the data in these tables.
- Temporarily remove the parameter from the datasets for the top tables and run the report. If data appears, the issue is with how the parameter is filtering the data. You may need to adjust the parameter or dataset query to ensure it includes Ship To and Bill To data.
- Confirm that the dataset queries for Ship To and Bill To are pulling the correct data. For example, if the query uses something like WHERE order_no = @OrderNo, ensure the @OrderNo value has matching records with Ship To/Bill To data.
- Double-check that the parameter is correctly applied across all datasets. If the parameter is based on order_no from the bottom table, ensure the top tables’ datasets are linked appropriately.
- Add a temporary table or text box to display the raw dataset output for Ship To and Bill To (without filters). This can help confirm if the data is being retrieved from the source.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Very much appreciate your message, thank you!
- v-ssriganesh
Hello Avery001,
Thank you for the update. I’m glad to hear you were able to resolve the issue—it’s great that you identified the mix-up with the "Bill2" and "Ship2" fields in your database. These kinds of mistakes can happen, especially when working with databases that have similar field names.
Since the issue is resolved, please mark it “Accept a solution”, as it might help others in the community who encounter a similar issue. Thanks again for sharing your solution.
Best regards,
v-ssriganesh