Get xlsx file from website
Hi guys, I am trying to find solution how can i link external data source to PBI . In my case my data is .xlsx file located on web page, and i have several of them. So basically i need get excel files from web pulled in to PBI and have it automated, because this files refresh each day. i have this (did use custom name to protect source web page - name.something.com/admin file1_2023-01.xlsx file1_2023-02.xlsx file1_2023-03.xlsx file1_2023-04.xlsx file1_2023-05.xlsx
Power BI Slicer - Between Dates don't get the latest date
Hello everybody!! I need some help with the date slicer on Power BI Desktop. When I create my Dashboard, I put an slicer between two dates, that are my first and last date based on my Calendar table (it's based on my first ticket creation date, on my tickets table, and "today" function). After, I publish it on my Report Server, set the schedule refresh, everything is okay. But on the next day, when I'll check the Dashboard, after the refresh, the last date wasn't the most recent date (or today, in that case), but the date when I published the Dashboard, so the viewer needs to slide the filter to the right to get the actual date, or click on the "clean filters" button. That's the example of date filter that I'm using. It was published on Jul,11 (it's on Brazilian format), and the second image, is the today refresh. Note that the first date changes too, because the Dashboard was published with data from Apr, 11 2019 to Jul, 11 2024, so at the refresh, my source data was only after Jan, 2 2023 There's some solution based on this? I've the latest release of Power BI Desktop and Report Server, but I didn't find any settings to do that. I've searched in a bunch of topics here, on Stack Overflow, Reddit, but didn't find anything specific for that.
Break a Line Graph when no data
Hi, Is there anyway to break a line graph when no data is present on a combo bar/line graph? No data was collected from 2019-2022 and the bars reflect this, however the lines look like there is data: I have tried to change to type to 'Categorical' however this then doesn't show it in date order, which it needs to be as it needs to show yearly changes in numbers. I could set to 0 but that would then look like there was sharp increase from 2022 to 2023 so ideally looking for a full break if possible. Is there a solution to this? Thank you
data multiplexing
Hello everyone, I have 2 tables, one of them contains store code, sales amount, sales amount, year and month data between 2021 and 2023. My other table contains store code, target, year and month data between 2021 and 2023. I associate these two tables with the store code. However, while the store's sales amount is correct, the target is incorrect. I did a lot of research on why but I couldn't find it. Can you help me with this? Thank you good work
Question on data limitation
I am in the beginning process of developling a data governance process at work. Does it make sense to require everyone who publishes a report to go through the PowerBI pipeline deployment process? I am skeptical because we currently already have an ecosystem of 140 workspaces. About 20% currently use the pipeline deployment process. If we create a governance that requires everyone to go through the pipeline deployment process, this would result in 300+ workspaces. My concerns are does this become to monstrous to manage? What is the best practice? and will I run into data storage issues? I know premium capacity allows us to have up to 100TB worth of data. The 1000 dataset limitation also scares me. What does this mean for pipeline deployment?Chart with last 4 weeks' data and secondary chart with just last week's data
Hello! This is my first forum post so please be understanding if I post too much info, I want to be 'easy' to help 🙂 I am trying to show 4 weeks of data in a chart, which is easy, but on the same power bi page in a different chart, show the most recent week worth of data too. I have the data automatically uploading from a database source. The data I have currently looks like this in my query, with the current chart showing the equipment name on x axis, and the OEE percentages on Y. There is a slider that is linked to Shift ISO column so that the last 4 weeks of data can be displayed. Is there any way to make a chart that only shows the last week's worth of data based on the time of accessing the power bi? thank you!Power BI Dax? - Subtract from Running Total Power Query, if statement, new measure or quick measure
I am trying to see what is the easiest way to do a running subtraction. If statement, new measure or quick measure in Power Bi Dax Sales Qty is 1.2 million (1,200,000) for each order. See table attached. I want to subtract for every order from the available qty so the Available Qty decreases for every new order listed with the same part. Available Qty" should 5,390,000 --> 4,190,000 --> 2,990,000 --> 1,790,000, --> 590,000, --> -610,000, --> -1,810,000 etc. Would like to do this in Power Query, if statement, new measure or quick measure if possible? My goal is to get a new Column Created Called "Actual Available Qty" should 5,390,000 --> 4,190,000 --> 2,990,000 --> 1,790,000, --> 590,000, --> -610,000, --> -1,810,000 etc.
