User Profile

happy30

Copper Contributor

Joined 4 years ago

8 Posts2 Likes

View All Badges

User Widgets

Recent Discussions

Missing start time and completion time in MS form excel file
Hi Team, There are instances where Ms form connected excel file doesn't record start time and completion time of the submissions, do we have any alternative solution to this ? Thanks
Sep 10, 2024 Place Microsoft Forms
microsoft forms
374Views
1like
1Comment
Re: "Insert table" option while connecting with Power BI dataset
It is now available !
Aug 30, 2024 Place Excel
462Views
0likes
1Comment
Re: "Insert table" option while connecting with Power BI dataset
Thanks Sergi. I can see my version is 2308 and whereas yours is 2312. So may be it needs to update with this version.
Jan 18, 2024 Place Excel
1.6KViews
1like
0Comments
Re: "Insert table" option while connecting with Power BI dataset
Yes, so Insert PivotTable option does work but "Insert table" option is not appearing as per screenshot shared. Can you please elaborate "Current channel" and are you able to view this option on your desktop ? Thanks.
Jan 18, 2024 Place Excel
1.7KViews
0likes
4Comments
"Insert table" option while connecting with Power BI dataset
Hi Team, As per the update on August 23, 2023, excel was supposed to have new option of "Insert table" while connecting with Power BI dataset. Currently, it is able to connect option "Insert PivotTable" and not the other option "Insert table". Does anyone know how to activate that option or is it not rolled out yet for any one ? The screenshot is attached and here is the blog link: https://powerbi.microsoft.com/en-us/blog/announcing-new-ways-to-create-connected-tables-in-excel-connected-to-power-bi/
Solved
Jan 17, 2024 Place Excel
excel
1.8KViews
0likes
6Comments
How to read excel cell having data pulling through separate tab via formula
Hi Team, I am using vlookup formula in one tab which pulls through data from second tab. The cell/data consist of long paragraph do we have any option to view data through hover over in excel cell rather than widening and increasing the height of excel cell ? Just wants to know if we have any such alternative to view data within cell having formula. Thanks
Oct 05, 2023 Place Excel
excel
Formulas and Functions
645Views
0likes
1Comment
Re: Replacing Nulls/30/12/1899 dates in Excel Power Query
This worked! Thank you
Jul 18, 2022 Place Excel
6.1KViews
0likes
0Comments
Replacing Nulls/30/12/1899 dates in Excel Power Query
Hi Team, I have been doing power query for data cleaning. I have seen that one of the calendar column (Date/Time) is in "Text" data type. When we try to change the data type in power query as "Date/Time" Data type, all the null rows in that column brings date like 30/12/1899. Can anyone advise on this how to get rid of this dates or replace those dates or nulls to something else we want or may be we can keep as blank? Thanks!
Solved
Jul 18, 2022 Place Excel
excel
6.3KViews
0likes
2Comments

Recent Blog Articles

No content to show