User Profile
ITstod-IE
Helper I
Joined 3 years ago
User Widgets
Contributions
Re: PowerBI Not Finding Custom Connector
Old thread but just had this issue when installing on a new PC 1. Create the folder Power BI Desktop and subfolder Custom Connectors. C:\Users\Name\Documents\Power BI Desktop\Custom Connectors It's crucial that the folder is named Custom Connectors, any other spelling will not work 2. Place the .mez-file in the subfolder 3. Edit the security access to Custom Connectors folder, add PBIEgwService 4. Install On-premises data gateway, and name it. Change the connection folder path to the one you created 5. Edit the settings in PBI, Archive > Options and settings > Options> Global > Security Set Data Extensions to Not recommended if you're using an inhouse-made custom connector DoneCalculate if item was in stock the day the order was said to deliver
I'm building a report where we calculate the delivery security, can the warehouse pack and deliver the items in time in relation to the date we promised to deliver. The calculation and "tags" on the rows are working for all warehouse stored items. But we have some items we don't store but place a purchase order to the supplier when we get a sales order. Example: If one of these items was promised to be delivered on 2025-10-20 but the delivery from the supplier was delayed and we only got it on 2025-10-25 then we want to tag the order as delayed. I have a table doing a running total, and am using the DAX below to show the latest inventory balance. But I can't figure out how to compare the information in that table with the order table. LastInventoryBalance= LASTNONBLANKVALUE(InventoryB[Datum], SUM(InventoryB[InventoryNumber])) Below is a brief summary on which tables we use and the columns. Order and InventoryBalance both have a relation to the date table and the item table. InventoryBalance use OrderDate in the relation to the Date table. Order [OrderDate],[PromisedDeliveryDate],[ItemNbr] InventoryBalance [Date], [InventorySum], [ItemNbr] Date [Date] Item [ItemNbr]Re: Can't connect to Dynamics 365 Busincess Central Finance APP
Hi v-venuppu, it's not resolved yet but we know what to do now. The financial reports below were no set up in the BC environment, and the setup for the Account schedule names were ofcourse also no done earlier. A collegue of mine will set up the below reports in BC so I can select them in the setup and the hopefully everthing will be working.Embedding PBI to Business Central stopped working
Translation: "Couldn't authenticate with Power BI. Try to log out and then in again. This issue commonly occur if you no longer have a licence for Power BI or if you recently changed you e-mail or password." This week the authentication between MS Business Central and Power BI stopped working. The reports work fine in PBI Services and all members can log in and look at the reports there. No changes has been done to the licences or any ones password. What can we try to fix this?Re: Avg number of sales per orders with the same item
Hi This is some dummy data, all columns come from the same table. If possible I want the avg column next to NrSold I was mistaken about how the table was set up. I didn't have all the items uniquely on the rows but I also have the order number which gave me some headache Dummy data DokNr ArtNr NrSold 1 1 1 2 1 3 3 1 1 4 1 1 5 1 4 6 2 3 7 2 1 8 2 5 9 2 1 Wanted result DokNr ArtNr NrSold Avg 1 1 1 2 2 1 3 2 3 1 1 2 4 1 1 2 5 1 4 2 6 2 3 2,5 7 2 1 2,5 8 2 5 2,5 9 2 1 2,5
