Category: Business

Excel Why IMAGE Function Changes To CONNECT Error

Posted on by Annie D

Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error!
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic Continue reading “Excel Why IMAGE Function Changes To CONNECT Error” →

Publish/Migrate your RDL files from Power BI Report Server to the service

Posted on by Annie D

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how!

Plan to migrate .rdl reports to Power BI
https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi

Blog Announcement:
https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751

Public RDL files to Power BI
https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— Continue reading “Publish/Migrate your RDL files from Power BI Report Server to the service” →

Uncovering the Power of Enterprise Data Modeling with Chris Barber

Posted on by Annie D

With his financial background and data modeling expertise, Chris Barber, a Microsoft MVP, explores the irony of his journey to discover the optimal data model, a task that requires both technical knowledge and a judgement call, to uncover the key to his clients’ successful decision-making.
Chris Barber is a Microsoft MVP and chartered accountant with a Masters in analytics. He has presented at Microsoft Reactor and the London Business Analysts Group, and runs the website Starchema.co.uk, which has over 1000 people taking his finance course. He specializes in large scale data modeling and financial reporting.
Chris Barber was always interested in Power Continue reading “Uncovering the Power of Enterprise Data Modeling with Chris Barber” →

Excel Create A Personal Macro Workbook – 2373

Posted on by Annie D

How to Create a Personal Macro Workbook in Excel.

I have a lot of other videos where I want you to put a few lines of VBA into your Personal Macro Workbook. I am always thinking that many people won’t have a Personal Macro Workbook. My goal with this video is that any time a future video mentions the Personal Macro Workbook, I can ask you to watch this video to create a Personal Macro Workbook and then you can go back to the other video for the VBA code for that particular task.

Table of Contents
(0:00) Excel Create a Personal Macro Continue reading “Excel Create A Personal Macro Workbook – 2373” →

Provide data lake access with Azure Synapse Analytics

Posted on by Annie D

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what’s missing!

Azure Synapse Access Control
https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview

How to set up access control for your Azure Synapse workspace
https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control

Control storage account access for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=user-identity

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— <a href="http://twitter.com/guyinacube" Continue reading “Provide data lake access with Azure Synapse Analytics” →

How To Use The GROUPBY Function In Power BI

Posted on by Annie D

In this tutorial, Sam will run through how to use the GROUPBY function in Power BI with a few examples. This is a similar table function to the likes of SUMMARIZE and SUMMARIZECOLUMNS, but it has some unique nuances to it that are interesting and worth diving into more deeply.

*****Video Details*****
00:00 Introduction
01:55 Creating tables using GROUPBY
03:58 Using the CURRENTGROUP function
05:28 Working out GROUPBY inside a variable
06:33 Return results using MAXX function
06:54 Checking out a specific customer

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE Continue reading “How To Use The GROUPBY Function In Power BI” →

Excel Sum The Comma Delimited Numbers From One Cell – 2372b

Posted on by Annie D

Om asks: I have 123,413,413,1352,244­ in a single cell.
There are many numbers with commas in between in each cell.
How to Sum all the numbers using a formula?
I don’t want to use Text to Column.
By the way, it is Excel 2010.

I use Brad Yundt’s three-line VBA function to split the numbers.
Then Excel formulas to sum them.
Also, an easier formula if you have Microsoft 365.

Table of Contents
(0:00) Sum all comma-delimited numbers in cell using an Excel formula
(0:19) Easy solution with TEXTSPLIT
(0:32) Switch to VBA for Brad Yundt Splitter code
(0:55) Using SPLITTER custom function in Excel
(1:25) Wrap up with Wally & Nancy

How To Easily Create And Organize Multiple Measures At Once In Power BI

Posted on by Annie D

In our past video, Brian showed how to automatically kill unused columns and measures in Power BI. Now, he’ll demonstrate some cool time-saving techniques on how you can create and organize dozens of measures at once, while also setting format strings and turning off aggregations. 

*****Video Details*****
00:00 Introduction
01:04 Data model
01:50 C# script
02:18 Fact table
03:24 Measures table
04:00 Metadata Mechanic Pro

*****Related Links*****

Tabular Editor 3:
https://tabulareditor.com/

Tabular Editor 2: (Free)
https://github.com/TabularEditor/TabularEditor
Metadata Mechanic Pro (part of Enterprise DNA Power Tools Suite)
https://www.enterprisedna.co/tech/power-tools/

Metadata Mechanic (Free)
https://github.com/gdeckler/MicrosoftHatesGregsQuickMeasures
GitHub Gist Bulk Measure Creation Script
https://gist.github.com/bjulius/8e71fde3e82574d278b9b06093583905

GitHub Gist Countrows Measure Continue reading “How To Easily Create And Organize Multiple Measures At Once In Power BI” →

Power Query Insert Blank Row After Each Group – 2372

Posted on by Annie D

Back in episode 2359, I needed to add a blank row after every group of names. Although I was already in Power Query, I went out to Excel to add the blank rows.

Several people commented with code to add a blank row after each group in Power Query. Thanks to @BillSzysz1 @radosawpoprawskiyourfriend769 @GeertDelmulle Rico S and Suat Ozgur for guiding me on how to add one line of M code to my query.

I am at that stage in my Power Query journey that I prefer to do everything in the Power Query editor. Once I switch over to the advanced Continue reading “Power Query Insert Blank Row After Each Group – 2372” →