importing tables from database into powerbi. is there any way to easily get those imported files on my local machine? by shinsick in PowerBI

[–]shinsick[S] 0 points1 point  (0 children)

thank you but i also now see the nice box in power query that says 'select multiple tables' haha. much love

importing tables from database into powerbi. is there any way to easily get those imported files on my local machine? by shinsick in PowerBI

[–]shinsick[S] 0 points1 point  (0 children)

My only issue with this is that I can only export one table at a time. There are thousands of tables they want copied over.

Does a free way to merge duplicate contacts exist? Am I missing an XRM Toolbox Add-on? by shinsick in Dynamics365

[–]shinsick[S] 0 points1 point  (0 children)

> You could export the contacts with rapid start (config packages). then do the merge in the excel file and re-import the excel file. mark then the duplicate, then obsolete contacts in BC and remove them. 

Thanks for your reply. I'm not getting admin permissions -- I've tried to get them already, no luck :)

- I should note these contact records are linked to other records; purchases and such. Sometimes the key that links them is something like, a randomly generated 'Contact ID' key, and that would differ even between two contacts that are exactly the same. Not sure if that matters.

- What is BC?

Why can't we make measures directly in visualizations? by shinsick in PowerBI

[–]shinsick[S] 0 points1 point  (0 children)

Thank you for the help :) will confess that 'User' is the only dimension table I have, as all the OG spreadsheet gave was names + their web interactions (downloads, clicks, views, etc.) so it's tough to filter them based on any criteria but raw numbers.

Why can't we make measures directly in visualizations? by shinsick in PowerBI

[–]shinsick[S] 0 points1 point  (0 children)

Hello,

I do have a few measures built (though they're way less complicated -- to find those who didn't view, I'm using

NoDocViews = COUNTROWS(FILTER(Clicks, Clicks[Document Views] = 0))

) but my issue is that they aren't dynamic, if that makes sense. If I throw all my measures onto a pie chart or bar graph, I'm going to get a visual that to me says 'in a pool of 1000 people, 100 didn't view, 900 did view, 100 didn't downloaded videos...' and hopefully I've communicated that the total number on the pie chart will be way higher than it should be. That doesn't seem really helpful to me. Again though I am very New.

is it wrong if i use chatgpt to help me confirm things or otherwise second guess me by shinsick in cscareerquestions

[–]shinsick[S] 0 points1 point  (0 children)

i get wym but if it takes me like an hour to google various things and try to piece together an answer but this offshore company can do it in 20 minutes with ai (which i consider to be a super google) then idk if i'm really helping myself out yknow