Forum Discussion
Adding comment data to an uneditable database
jshull First, are you connecting to an existing Power BI dataset and therefore a "Live" connection or are you using DirectQuery? If DirectQuery you have the option of a composite data model, which allows you to import data to add to your dataset. That option is not available for Live datasets yet.
For your second question, there are wasy of doing it but it mostly leads to sadness. ImkeF has some solutions for this I believe.
Greg_Deckler Thanks for the quick response!
Unfortunately this is a live dataset. I've tried using other methods of connecting to the database - like Import - but Power BI ends up freezing up every time that's attempted. IT support's answer on that is "only use the live connection please."
Hah, "sadness" is what I expected, but I'll take any ideas! I assume the real solution here is on the database side - to add a Week Ending In" field - but I have no way to change that.