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
Modal Dialog API 3.8.1
Greetings all, I've experimented with the new feature that came with new API and I ran into some issues (see attached image). Has anybody been succesful in implementing a modal dialog? A small example from which I could extrapolate would mean the world to me. 🙂 Thanks in advance, Dusan
DAX code filtering tabled based on selected value (show other values)
Hi all, I have an issues to which I cannot find the solution. I hope someone can help me out. I've created an example dataset to explain the problem: customers order food and drinks in a restaurant. They can order multiple types of food and drinks during 1 visit. Here is a sample of 5 different customers with their orders: I can edit this table to make it a one record per customer list: Now what I would like to know is when I select one item in a slicer/filter, what are the other most ordered items per type (food/drinks) based the customers that ordered the selected item? Example: I select as item Fries. Customer B, C and E ordered Fries. During the same order, they also ordered other food and drink items. I want to count the number of times the other items were ordered to see which item is most often ordered together with fries. This is what I would like to see then: My thoughts were to first create new DIM table with the type and item combinations (a food and drinks list) which can then be used for the filter. I can create a relationship between the new DIM table and the FACT table in the model view so that I can filter the customers with orders that contain the selected item. Then I somehow need to use this list of selected customers to filter another table (a copy of the original FACT table with all the customers and their order information?) so that I can see the whole order of these customers. And then I can create a visual of the number of items, per type, in which I exclude the selected item. I hope someone can help me out 🙂 Many thanks, AnneReport Server does not complete Data Refresh
Hi all, I have the following issue several days ago. When I publish a new report or re-configure the Screduled Refresh for old reports, the Status of Scheduler stucks in "Updating" Status. But the old reports that run and were scheduled 1 month before (without touching them) are working properly (they finish the scheduler correctly). Here some information of my environment: If need some additional information please just let me know. Thanks. Oscar.DAX Calculation - HELP
I have this summarized dataset grouped by multiple variables. This is a screenshot of a table I created from the dataset (other variables are being used as slicers), each index point has mulitple rows in the main dataset 2023 is defined as CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 }) 2022 is defined as CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2022 }) I wanted to create two seperate measures each for 2023 and 2022 that will take the previous row value and then add it at each step with the current value at that index point, it should look something like this
