User Profile
Analystdata
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
CTE's to Direct Query Method in Power Query
Hello Everyone, I am currently working on developing a Bill of Materials (BOM) report in Power BI. Given the substantial data volume, we need to leverage a parameter in Power Query using the Direct M Query method. We initially attempted to implement the parent-child hierarchy using Common Table Expressions (CTEs) in SQL. However, we've encountered an issue: Power BI does not support loading data from CTE scripts directly through the Advanced options. Could you please suggest alternative approaches or solutions to handle this situation effectively? Your insights and guidance would be greatly appreciated. Thank you in advance for your support.Solved1.9KViews0likes1CommentPower BI Service Refresh Issue
Hello Everyone, We are currently facing an issue in the Power BI Service, where many of our files are failing to refresh. Additionally, our manual attempts to download and refresh these files have also been unsuccessful. Your expertise in resolving this issue would be greatly appreciated. Thank you in advance for your valuable assistance.613Views0likes3CommentsToggle values of the table
Hi Everyone! I am reaching out to seek assistance with implementing a slicer in Power BI. The objective is to create a slicer with values 0 and 1, where selecting 0 will hide entire rows where the sum of values (Amount + X + Y + Z + XZY) equals 0, and selecting 1 will display the entire table. I have attached a snippet for your reference. Amount X Y Z XZY REVENUE GROSS SALES 28686415.9 1.003 2177377 1.00299 203039.4 SALES COMMISSION INCOME 0 0 0 0 0 RENT REVENUE 0 0 0 0 0 LESS: SALES RETURNS & ALLOWANCE/DISCOUNT -7108.57 -0.003 -6483.87 -0.00299 -624.7 NET SALES 2373307.31 1 2170893 1 202414.7 Your expertise in resolving this issue would be highly appreciated. Thank you in advance for your valuable assistance.Solved764Views0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.