Posts by Adam Lincoln • 33 points
7 posts
-
-2
votes1
answer46
viewsA: Error publishing Power BI report on Workspace
After many tests and analysis with the Microsoft team we found the problem. To use the local Analisys Service in connection with Power BI, it is mandatory to use Active Directory as a form of…
-
1
votes1
answer46
viewsQ: Error publishing Power BI report on Workspace
Good afternoon I have the following structure mounted on my personal machine: SQL Server -> Server Analysis service -> Power BI -> Power BI report published on the Web. Everything works…
-
-3
votes1
answer602
viewsQ: How to sort a column in the pivot_table Pandas
Here’s the thing, I need to sort a pivot table to show me the values from highest to lowest. impute_grps = df.pivot_table(values=["winPlacePerc"], index=["matchType"], aggfunc=np.count_nonzero)…
-
-1
votes1
answer103
viewsQ: (Pandas) to_scv error in parameter Sep=
I am trying to play the content of a dataset on an scv, however the parameter SEP =';' stopped working. df.to_csv(path,r'\20191122_Consolidados_camara_de_retencao.csv', sep = ';') When trying to run…
-
0
votes1
answer156
viewsA: INTO OUTFILE command saves file without header, how to set header?
I found the exit. SELECT "ID", "AGENT" UNION ALL SELECT ID_AGENTE, NM_AGENTE INTO OUTFILE 'C:/Users/ADAMLINCOLNOLIVEIRAS/Box Sync/Sustain/arquivo2.csv' FIELDS TERMINATED BY ';' FROM Agents In bold I…
-
0
votes1
answer156
viewsQ: INTO OUTFILE command saves file without header, how to set header?
Good afternoon, everyone, I am running the following command to save files coming from MYSQL. Works however I cannot save the file with header, the data comes without header. SELECT * INTO OUTFILE…
-
3
votes1
answer1355
viewsQ: Password or invalid user when logging into oracle database (ORA-01017)
Good morning, everyone, I need to set up an environment for a course. For this I installed the Oracle database and SQL Developer. In the oracle database I have the SYS user working perfectly. The…