- Видео 7
- Просмотров 23 485
My Accounting Tricks
Индия
Добавлен 12 май 2020
My Account Tricks blog is educational web platform which created to share articles and tutorial on Finance, Accounting, Taxation, Costing, Accounting Standard, Journal Entries, Excel, Advance Excel, VBA, SAP, SAP FICO, ORACLE ERP, ORACLE EBUSINESS SUITE, SQL, Data Science, Data Visualization, POWER BI, Tableau BI, Oracle BI, Accounting examination preparation, accounting job, Financial Analysis, Data Analysis, Financial Planning and more
Visit - www.myaccountingtricks.com
Facebook - MyAccountingTricks
Twitter - MyAccountingTr1
Linkedin - www.linkedin.com/groups/13868245/
Visit - www.myaccountingtricks.com
Facebook - MyAccountingTricks
Twitter - MyAccountingTr1
Linkedin - www.linkedin.com/groups/13868245/
Power Bi's New Card Visual Is Amazing!
First impression of Power BI New Card Visual. Details video will publish soon.
How to activate Power BI New Card Visual
Download the latest Power BI Desktop software
Go to File ,
Options & Setting,
Options,
Preview Features
Activate New Card Visual
How to activate Power BI New Card Visual
Download the latest Power BI Desktop software
Go to File ,
Options & Setting,
Options,
Preview Features
Activate New Card Visual
Просмотров: 616
Видео
Transparent Table Background Color in Power BI Table & Matrix Table
Просмотров 10 тыс.2 года назад
How to Remove Table Background Color in Power BI How to Remove Matrix Table Background Color in Power BI How to make Transparent Table Visual in Power BI Desktop How to make Transparent Matrix Table Visual in Power BI Desktop
EXCEL : Power Query Tutorial - Part 1 | HR Project (35 Tricks)
Просмотров 6364 года назад
Power Query Beginner Tutorial. 35 Minutes Video cover 35 Power Query Steps for HR Salary Calculation project for Excel 365, Excel 2019, 2016, 2013 2010 users What are the Benefits of POWER QUERY How to use POWER QUERY POWER QUERY Editor in Excel 365, Excel 2019, Excel 2016, Excel 2013 & Excel 2010 How to Insert or Pull or Import Excel Sheets and Files into POWER QUERY How to Check Header, Remov...
POWER BI: 3 Way Import or Pull Data from Google Sheets and connection (SOLVED 2020)
Просмотров 6 тыс.4 года назад
How to Pull data or import data from Google Drive and Google Sheets into POWER BI Setup Connection between Google Drive Sheets with POWER BI How to connect POWER BI with GOOGLE SHEET How to connect Google Drive Files with POWER BI Create Report Visualization in POWER BI with Google Sheet Data Import Google Sheets data into POWER QUERY POWER BI TUTORIAL FOR BEGINNER TO ADVANCE POWER BI and POWER...
POWER QUERY: 3 Way Import Data from Google Drive to Excel (All Excel Version)
Просмотров 5 тыс.4 года назад
3 AWESOME PROCESS TO IMPORT DATA OR PULL FROM GOOGLE DRIVE TO EXCEL (ALL EXCEL VERSION). Google Drive और GOOGLE Sheet के लिए डेटा कैसे प्राप्त किया जाए, Excel और POWER BI, डाउनलोड किए गए हर समय के बिना 3 PROCESS TO IMPORT DATA FROM GOOGLE DRIVE TO EXCEL WITHOUT ANY DOWNLOAD. Import or Upload Google Drive Data into Excel and Auto Refresh of Data How to Connect and Auto Refresh Google Data into E...
What is POWER QUERY and its benefits | POWER QUERY BEGINNER TUTORIAL
Просмотров 1664 года назад
POWER QUERY क्या है और इसके क्या फायदे हैं. EXCEL AUTOMATION THROUGH POWER QUERY. HISTORY OF POWER QUERY. POWER QUERY for POWER BI and POWER QUERY. POWER QUERY BEGINNER GUIDE TUTORIAL. POWER BI BEGINNER GUIDE TUTORIAL. ADVANCE EXCEL TUTORIAL. VBA ALTERNATIVE. STEP BY STEP POWER QUERY TUTORIAL, POWER QUERY TRAINING WEBSITE - www.MyAccountingTricks.com CMA PIJUSH ROY - www.myaccountingtricks.com/...
Convert Matrix Table to Simple List Table in Excel
Просмотров 1,6 тыс.4 года назад
How to Convert matrix table to simple table in excel How to Convert crosstab table to list table in excel How to Convert crosstab table to simple table in excel Website - www.MyAccountingTricks.com Subscribe Website NewsLetter - bit.ly/mat_email (Dont forget to Click the Verification Email which you receive after subscribe) Article Link and Download PROJECT File www.myaccountingtricks.com/2020/...
100%
Thank you very much, it's helpful 🙌🏻
Hi, thank you for the video, it was really helpful. Do you know if it is possible to do method 1 with restricted access as well? I tried method one and it worked for unrestricted access but sadly not for restricted access. However to ensure the data safety at my company I need to use the restricted access. It would be great if you had a solution for this. Thank you. :)
YOU ARE THE GUY MY MANNNNNN! YOU GOT THE BOLSSSSS
Thank you so much, from Vietnam.
Welcome
Thank you so much for sharing this video! I have a dark theme gradient background dashboard, but couldn't figure out how to make my report element transparent. I appreciate everything you've done. 😀
Glad it was helpful!
Have you ever had the issue where the "no color" option disappears after you assign something color? The option with the red line through it for no color is gone. Thanks for the tut!
Yes I faced same sometimes @Ryan
It seems that I need "download" right for the document from the Google Drive. "View only" is not enough.
Please use Points 3, you can use Google Drive file without download them Please let me know
Ami kartick bolchi
Good pijus
For your 3rd method, can I make power query connect to Google drive folder (which has multiple excel files in it)?
Yes you can
Very Good !!
Thanks, Please subscribe, like and share to support the channel
I need to import data from a drive folder to power query (excel). do you have any method for this?
Yes, It is possible I will upload this process and let you know the link Subscribe, Like and Share to support this channel
@@MyAccountingTricksright, subscribed :) tks
Your Google Drive contains excel files or google sheet?
@@MyAccountingTricks excel files (.xlsm)
@@MyAccountingTricks Excel files :)
This video is the solution to a basic problem. The real question and challenge is: How do I connect a Google Drive Folder to PowerQuery / PowerBI? There doesn't seem to be a real answer to this....
I will upload video on this solution soon
Dear Mr Pijush Roy@@MyAccountingTricks _ i thank you for your instructive video on importing single excel. Like Lara on the above, i have been searching for the same query in the website but to no avail. I eagerly await your new video on how to power query multi numbers of excel files from Google Drive. Thank you. From Tan LC
Hi Lara, sorry for the delayed Your Google Drive contains *excel files* and you want to Combine them in Power Query or Your Google Drive contains *Google Sheet* and you want to Combine them in Power Query Please let me know,
@@MyAccountingTricks it was CSV files sitting in a Google Drive folder
@@laravanwyk5474 did you find a solution for your query??
Hai,i use step 3 to get my data.after publish to power bi i was unable to refresh my dataset.Can u assist me plz?
Which type of problem you facing. Could you share error message or share screenshot via [imgur . com]
Bhai sahab chaaa gaye hain ap tou. I got fix. Thanks
Thanks
non G suite though so methods 1 and 2 shall be fine at 2 where is straight forward and secure... bohots acha!!!
Thanks
You save my life with the last step... Thank you I was not aware of the Drive File Stream, instead of download the google drive app this option is more simple and very helpfully... Saludos desde Mexico
You are welcome!
Nice project but one piece of advice is please say properly more people will watch.. Nice project though!
Thanks Friends, I will try my best
the first video which helps thx from germany
Thanks, If it is helpful, please share, it will helps me lots
Hi, after publishing PBI desktop which is connected to GoogleSheets...There refresh issues in PBI services .. Can u help
Yes, I always help with any issue. Question 1 - How you connect Google Sheet & POWER BI? Follow any process mentioned in this video. Question 2 - Please share a screenshot of your issue, you can use imgur[dot]com to provide me the link to your issue.
Is there any way to get live data (real time data) from google sheet
If you using any of three-step, you can get real-time data when you refresh or schedule refresh POWER BI datasets. if you face any problem to get real-time data from Google Sheet, please let me know below. (please explain your problem)
MCQ/QUIZ - When you use APPEND QUERIES between two tables, which of the following is mandatory to maintain A. Column Name of Both Tables Should be the same B. Both table should be identical (same column) C. Data Type of the column should be the same D. All of the above (Post your answer reply, I will reply and explain)
Which Process You Like and Want to Try First?
Sir , please improve audio of this content so that it would be more helpful to understand
Sure, I will working on same.
Plz upload more videos about SAP
Yes Sure
The sound quality is very low
I will try to improve in coming video
👍
Thanks, stay connected and share with your friends.
Great!!! Very informative. Carry on bro 👍
Thank you, I will