Tag: reporting
-
Not all my records are showing up in my Power BI groups
I was just working on something in Power BI and saw some weird behavior. I had created some groups in Power BI (learn how to do that here) and a weird little peccadillo popped up. I had opened my Power BI Desktop file earlier on in the morning. Later on, I realized I wanted to…
-
Create PivotTable unsuccessful – Power BI and Excel
Every once in a while, I’ll Google something and get 0 results. I hate that. This time, it was me trying to connect to a Power BI data model through Excel so I could use the cube functions and make a fancy little Excel-based dashboard. I swear, I don’t know how anyone does anything in…
-
Easily building an income statement in Power BI
Want an easy way to create either an income statement or a balance sheet in Power BI? Here’s one straightforward approach that worked for me!
-
How to customize Dynamics 365 Business Central (maybe)
I’m trying to build some Power BI reports using Business Central general ledger data. First attempt at doing this was to connect Power BI to the Business Central connector and using the G_Lentries web service. This was working just fine for a while. However, I ran into a snag. During my data migration, I ended…
-
How to find which fields to use when customizing Report layouts
Back to Business Central. Similar to Finance and Operations, the out-of-the-box business documents (sales invoices, in this case), leave much to desired. Thankfully, UNLIKE Finance and Operations, Business Central has a pretty straightforward way to handling customizations of these reports. I wanted to use the Word-based reports instead of dealing with customizing Reporting Services reports.…
-
How to quickly use ChatGPT with Power BI and Dynamics 365
Do you want to know how to calculate utilization for your consulting company? Me too! Thankfully, I have Power BI and ChatGPT is around to help…
