Bc0303 Tracker

Re: PowerBI Wont Connect to Semantic Model

Bc0303 — Fri, 03 May 2024 08:49:40 GMT

The source of my Data is Excel at the minute, so it goes into Alteryx then data maniluation is done and it spits out into workspace, it will be inevitably connected to a warehouse but at the minute its an excel file but we are introducing Alteryx so we are working on using it for all data purposes then PowerBI as the visual end.

Also what do you mean check the data is ok in Service? 😮

PowerBI Wont Connect to Semantic Model

Bc0303 — Thu, 02 May 2024 11:30:34 GMT

Hi,

I have created a work flow using Alteryx and then pushed out the data via the Power BI Output connection addon to my powerbi workspace, when i open PowerBI and then go into Get Data and select semantic model then choose the output file on my workspace I get this error.

Does anyone know what could be causing this or how I make the relevant changes to ensure I can connect to it.

Thanks!

Sparkline and Current Year Question in Matrix

Bc0303 — Wed, 24 Apr 2024 10:14:30 GMT

Hi,

Couple of questions in this thought id group them together as they are for the same matrix table, first of all is there a way I can ignore my Year filters on a sparkline ive created? as the Matrix table has the ability to show figures for each year using a filter but if you select a singular year the sparkline shows as a dot rather than a line graph?

Second one - is there a way to create a measure for example Sum of Cost for current year from todays date so it will only show in the measure the sum of cost for the year from today(), so next year it will only show next years data and this is uneffected by filters selected.

Hope that makes sense, thanks!

Percentage Increase Prior Year vs This Year

Bc0303 — Fri, 19 Apr 2024 10:44:03 GMT

Hi,

Im trying to add a column to my Matrix table which will show the Percentage increase/decrease of Volume from Last year to Current Year (this will be effected by filter so if I select 2024 it will compare 2023 to 2024 and so on the Matrix

My data looks like this in power BI, the Volumes are what I want to show but on the Matrix table I have it has a list of Activities A-H a few other measures that are summed by the activity and year (based on the filter on the page) then I want to have a column that says Previous Year Volume which will be a sum of Activity A for lets say 2022 then another Column that shows Sum of A for 2023 then a percentage of the increase or decrease so 50% increase or 30% decrease. THANKS in advance for the help

Date	Activities	Volumes	Checks	DS	Cost
2022	A	3400	1	4	55
2022	B	4005	0	3	56
2022	C	2221	2	2	6636
2022	D	2154	0	1	6564
2022	E	5244	0	3	36
2022	F	4586	0	3	785
2022	G	1564	0	2	3456
2022	H	15987	0	1	636
2023	A	1561	2	4	267
2023	B	3216	0	6	547
2023	C	6541	2	6	873
2023	D	3465	2	4	333
2023	E	3216	0	4	22
2023	F	321	0	2	515
2023	G	3244	0	12	6
2023	H	13525	0	2	7