Forum Discussion

croberts21's avatar
croberts21
Icon for Continued Contributor rankContinued Contributor
3 years ago

Get user input via PBI

Hi all. I would like to use Power BI Desktop in the following fashion. We are converting a spreadsheet to use PBI where the user would enter 2 numbers and PBI would get cost information from out database and calculate the cost of each batch of books to print themselves.

I have never seen PBI used in this way, as it's not a full programming language.

Currently the spreadsheet is shared via ms teams and someone must manually enter costs in the spreadsheet. We would like to grab costs for each part of a book from our database where they live. 

Is this even possible? How would I go about doing this? Are there more appropriate tools to do this?

Thank you!

 

No RepliesBe the first to reply