content

3 Topics

POST request with Power Query fails auth but needs to be Anonymous
The Web.Contents function needs to specify content for making a POST request, but can`t get auth right. I pass the credentials (APIKey) and it works on Postman, but if I do it anonymous in PB it fails saying that can`t verify the credentials, but if I change it to basic auth PB tells me that the query needs to be from anonymous source. The code looks like this, the main part ends at JsonResponse, I don't think that the transformation of data matters for this problem.
Solved
JangoChained
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
2Comments
Power BI App not showing Report
After this new release of PBI, graying out the "include in app" button and instead editing content, I cannot include new reports into the app. I've added a new report to my PBI space and trying to enable it in PBI App, under Content. This report shows in the Content edit page, but when I click Update app, the report is not there. I noticed that even though "include in app" is grayed out, it is set to "yes" for this report. How can I fix it to where the report shows in the PBI App?
Solved
lsoares
2 years ago Place Report Server
23KViews
1like
9Comments
Retention Rate by level of purchase
Hi, I calculate Retention RateY = DIVIDE([ConstantClientCount],[ActiveClientCountYearAgo]) and display it by different criteria (Departments, Region etc) The client request is to calculate the Retention Rateby by the level of purchase value per customer. Example High ( 25k plus), Medium (5k-10k), Low (5k and less). I added a calculated column in the customer table, which gives the level of each customer by overall average value for the respective customer. The problem is that in real life, a customer can buy one year for 5k, and the next year 10k and then 25k. Therefore, will move yearly between levels: Year 1 could be low, year 2 could be medium and year 3 could be high. The method I used will count the client, all the time, within the same category of purchase determined by the average of all purchases for this client. I need to display the Retention Rate, 5 years evolution, witch consider this client, in different categories of purchase ( if 2020, $25k, high),( if 2021, $2k, low ) Thanks for the advice or link or any other reference.
Solved
AH2022
3 years ago Place DAX Commands and Tips
873Views
0likes
2Comments