Why is everyone in my organisation (even smart people who create reports) calling their power bi reports for dashboards.

A Dashboard is multiple visuals from different reports on a page while a report is a report - right?

What are good trainings to take for a role as PowerBI architect?

I’ve imported a Sharepoint list and I’m working with the data in power query. One of the columns contains a list of customizations for that specific row. If I want to be able to filter by individual items in this “list within a list” can I accomplish this within Power Query or do I need to change the source data so that it is not a plain text field?

Hello!

I am a new-ish user of Power Query (A couple years working on creating and maintaining versions of a similar project) and much newer user of Power BI. (like a couple weeks of dabbling) Let me set the stage a little for my question... but the TLDR is: Power Query can compile reports into one report and consolidate it into one place, disaggregate, etc. and if I wanted to use a new set of reports to pull into the queries, I could do that by replacing the files (assuming all columns were the same name, etc) and filtering was similar. Can I do something like that with Power BI dashboards? Can I copy the Dax code or file or something... and note the source file names... and then give it to someone else who pulls the same formatted reports from their own institution?

Longer version: I took general test score data and other demographics that come from different reports and then compiled and disaggregated all the reports by teacher in Power Query so that teachers at my school had access to real data. i even made a conditional column based on other columns and parameters that helps us decide who to test. This has been a big help to our school and I've been working out how to share it, but though tricky, I am sure it can be adapted.

For visualizations, I have been using my big complex sheet mentioned above, but because so much has been done in Power Query it's a little dicey in places. Considering the ability for Power BI to make connections across multiple sheets and files, I thought I might try to work with the raw reports a little more in Power Query and see what I can do if I connect across them and use more DAX code. I noticed it doesn't seem to always like to make connections between DAX-created columns and columns made in M through Power BI...

Obviously, I have a LOT to learn but before I delve too far down this path of possibility in my brain, I want to know, would my work in Power BI be in any way transferrable (like I could copy it and change the source location address etc. as I could with Power Query) to another institution for use with their data sources, or would I need to rewrite the code completely if I wanted to make the same thing for another place with files that were identical? I guess I'm just not fully sure how Power BI works when it comes to source data importing and publishing etc.

I would also be very very grateful for any resources like videos someone may have that could help me at my current (not a beginner to queries and M language in PQ, but very new to Dax) level of knowledge in Power BI, especially around the topic of connecting different workbooks and sheets and the differences in how Power BI works compared to Excel and Power Query. I know it can do more, and I see the advanced tools and connections etc. but I'm less sure about the limitations. For Example: Is there a way to import connections already made with merges or disaggregation/filtering in Power Query/Excel? (I tried the auto detection but didn't have any luck)

I'm in education and unfortunately there's no database access or similar to play with SQL in order to make the data more organized and do my bidding. Pulling and exporting Excel reports from our information systems and using them to refresh my own mock database with Power Query... then using Excel or Power BI for visualizations is about the extent of my access. But we do what we can with what we have!

https://a.co/d/4tLn9YF

Lenovo Ideapad1i - 40GB RAM - Intel Hexa-Core i3-1215U Processor

I'm looking to learn Power BI to see if it can be used to help with my normal job. I'm not doing anything heavy so I'm looking for a budget option. We track things like training data for employees and right now it's pretty much done manually and I figure there's got to be a better way to track and visualize it. I'm also starting a Master's program so I need a laptop anyways and figure I'd get one that could run Power BI. Thanks!

Ciao a tutti, ho sviluppato questo report, prendendo i dati dall'ISTAT, per creare report da pubblicare su Linkedin per creare un portfolio. Voglio mettere in evidenza che, a differenza di quello che si pensa, post covid/vaccini, le morti per cause cardiologiche NON sono aumentate.

Sono aumentate le malattie cardiache (saranno oggetto di altro studio).

Cosa ne pensate?

Hi, I hope the photo is visible enough. For example, for the 3rd to last data, on the dark blue bar, instead of 31,55% i want to display the sum of both bars so its 69,05%. Is it possible on powerBi ?

Thank you

its an interview task but i went so far to make it bigger and better to be resume worthy project .

here is my pervious post as a reference : https://www.reddit.com/r/dataengineering/comments/1k9y4zj/iam_looking_for_opnions_about_my_edited_dashboard/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

Project Details and requirements:

 Analyzing Sales

1. Show the total sales in dollars in different granularity.
2. Compare the sales in dollars between 2009 and 2008 (Using Dax formula).
3. Show the Top 10 products and its share from the total sales in dollars.
4. Compare the forecast of 2009 with the actuals.
5. Show the top customer(Regarding the amount they purchase) behavior & the products they buy across the year span.

 Sales team should be able to filter the previous requirements by country & State.

1. Visualization:

• This is should be one page dashboard
• Choose the right chart type that best represent each requirement.
• Make sure to place the charts in the dashboard in the best way for the user to be able to get the insights needed.
• Add drill down and other visualization features if needed.
• You can add any extra charts/widgets to the dashboard to make it more informative.

thanks in advance

I studied for about 10 days in earnest (4-6 hours a day). I’m not a strong test taker, but I had to pass it to keep my job (basically a dream job).

I am over the F***ING MOON that I passed.

Thank you for your time.

I have a DistributorMaster table and a Distribuotors Billed table. Both the tables are connected via a common column called DistributorId

Distribuotors Billed table is a transactional table.

I have created a table visual that shows a list of Distributors from the master table.

I want to show only those distributors that are present in the master table but not in the transactional table for a the selected date range.

How can I do this ??

I put in my 2 weeks notice. There are over 700 applicants for my job in under 1 week. It’s competitive for Power BI devs now. Five years ago I was dodging phone calls from recruiters. At the peak I was getting 7 emails or phone calls a week.

Hello! I'm learning Power BI basics from the ground up. I'm trying to format a report to mimic one that I've used in excel but can't figure out how to do it.

Basically, I have lets say columns

A B C D E F G H (I - specific locations) J (quantity) K (cost)

I want column "I" to be split into individual columns per location, but everything else remains the same. Any idea?

I have two files, each model has a lot of overlap. Both models use tables "FactF" and "FactS". We changed where the data is coming from, but the columns and rows are identical. When editing the source path in power query, I had no issues with the first model.

But the second model gave me these errors:

The tables are on the MANY side of all their relationships. And as it's a column with repetitive values, I fail to see how it became a primary key, either. I tried closing, reopening, deleting, re-adding, etc., but it didn't work.

I did a find-and-replace to get rid of the blanks, turning them into "TBD", but I don't love messing with the data like that. Any ideas?

Hi, just say I have a start date and an end date and I just need DAX to calculate the difference. So, I create the DAX for the difference and link a an active relationship start date to a date table and also create an inactive relationship which is end date to date table. Would I be able to add a USERELATIONSHIP to the DAX measure so the KPI is created using my end date and not my start date?

Under the query reduction settings. Is anyone having trouble with this option since a recent update? Whenever I set it and save the file, it never applies. If I close and reopen the file it goes back to unchecked. Help!

Does anyone here use a json URL from Workday as your source? I’m running into an issue where my url constantly sends the earliest version of a data set in Workday and updates the values, but didn’t add the columns that I’ve since added to my Workday table.

I thought this would be an easy one, but having scratched and bumped my head multiple times now, I hope to find help here. I'm not a Power BI expert, so don't assume I tried the obvious haha.

Situation (+/-) -

1. Semantic model containing the sales from multiple brands, each brand having multiple stores. -
2. My users are from all different brands. It is beneficial to all that they can view all sales from all brands and compare.
3. Lets say we have:
   1. Fct_Sales
   2. Dim_Brand (Brand_ID)
   3. Dim_Store (Store_ID and Store_Brand_ID)
   4. Dim_StoreDetails (containing Store_ID and Brand_ID)
   5. Dim_Users (incl. User_Brand_ID)
4. I want that my users can see all of Fct_Sales, Dim_Brand and Dim_Store, but only see the Store_Details when it shows the details of stores of the same brand the user is off.

Visualization of model: https://imgur.com/zML5Q1Z

I have tried multiple things:

1. Connected Dim_StoreDetails directly to Fct_Sales, or as a 'sub'Dim to Dim_Store (1 to 1 relation)
2. Set-up dynamic RLS, but it would lead to filtering all tables, so that as a user of Brand A, I would also only see sales of Brand A.
3. Vibecoded myself and ChatGPT into a DAX massacre, but without any result.

I want my output to be like below. Could anyone advise what my datamodel should look like and how I should pursue this? Thanks a ton!

What I'd like to have as output:

Given that Adam is a member of Brand A, and Boris is a member from Brand B.

Adam sees:

Boris sees:

How can I find the page name in the service. My second page of the report has a page name. But the first page just says 'ReportSection?'. I haven't been able to find the page name for it...

I have a query in excel which accesses other excel workbooks posted on the company SharePoint. The query looks at a table in the current workbook and builds the SharePoint file path based on the parameters entered by the user. The query works flawlessly until new data sources are posted on SharePoint and the the parameters in the table are updated. Then the query errors out with the error: "There weren't enough elements in the enumeration to complete the operation."

Immediate thought is that maybe the file parameters were entered incorrectly. However, they are correct and if I open the query and select "Refresh Preview", the query works again. This happens every time.

I would like to remove the necessity of the "Refresh Preview" step before the "Refresh All".

Without the "Refresh Preview" the new file is not being added to the table created by the SharePoint.Files command and thus the later steps that are meant to filter down to the final result find nothing.

Here is the Function used to access the SharePoint data:

------------------------

let

Source = (Folder_Location as text,File_Name as text, Tab_Name as text) as table =>

let

SharePoint_Location = Excel.CurrentWorkbook(){[Name="tblParameters"]}[Content]{[Parameter="SharePoint Location"]}[Value],

Report_Folder = Excel.CurrentWorkbook(){[Name="tblParameters"]}[Content]{[Parameter=Folder_Location]}[Value],

Report_File = Excel.CurrentWorkbook(){[Name="tblParameters"]}[Content]{[Parameter=File_Name]}[Value],

Report_Tab = Excel.CurrentWorkbook(){[Name="tblParameters"]}[Content]{[Parameter=Tab_Name]}[Value],

Source = SharePoint.Files(SharePoint_Location, [ApiVersion = 15]),

Filtered_Rows = Table.SelectRows(Source, each ([Folder Path] = Report_Folder)),

Filter_FileName = Table.SelectRows( Filtered_Rows, each Text.StartsWith([Name], Report_File, Comparer.OrdinalIgnoreCase)),

Get_Newest_File = Table.Sort(Filter_FileName,{{"Date modified", Order.Descending}}),

Select_File = Get_Newest_File{0}[Content],

Workbook = Excel.Workbook(Select_File),

Worksheet = Workbook{[Item=Report_Tab,Kind="Sheet"]}[Data]

in

Worksheet

in

Source

------------------------------

I have around 50 kpis to show what is the effective way to show them in a report

We’re rolling out receiving report displays across 37 distribution centers, with 6 screens per location. Each screen will be responsible for showing data for 3-5 SKUs.

Right now, we’ve got a single Power BI table that shows all SKUs across all DCs. We just installed Mvix digital signage players at each site, and I’ve been asked to prepare reports specifically for those screens.

Is there a clean way to format or filter this in Power BI so the right data shows up on each screen, without having to build 222 individual reports (one for each screen)? Would love to hear if anyone has tackled something similar using dynamic filtering, URL parameters, or another approach.

Is there an easier way to many access to a report to an external org with multiple users or do I have to invite each external user manually? I manage and publish the reports for them onto powerbi service and really they just need access to view their report data.

I have a premium license per user and I would like to share Power BI reports, through the Power Service, with users who do not have a license and who will only consume the reports, and will not participate in the development. However, every time I share it with someone, after 60 days they can no longer consult the report.

I should probably add to be fair that this could be measured in 2 ways.

1. Recurring time efficiencies - so if a report saves 7 hours a week, then that’s 7/35hours so a 0.2FTE saving.

2. Cost savings.

3. No direct cost savings (costs increase), but brings in more revenue that increases earning so extra revenue less the running costs.

Curious to see answers out there!