powerbi

Hello there, I am querying a remote PB server by doing a POST to its REST url (something like https://XYZ/public/reports/querydata). The query is contained in a JSON file which looks like this { "queries" : [ { "ApplicationContext" : { "Sources" : [ {...

Good morning everyone. In my Excel file I have an "Orders" table which among other things includes the field "Hours needed", which is basically the time in hours required to complete the order and the "Date of order" which is the date when the order was carried out in dd/mm/yyyy format. You can...

Dear Community, I'm trying to move my excel skills into PowerBI for profesionnal reasons. Here is my case : I have a table of Non Conformity (NC) with creation and closure date columns. My goal is to know the quantity of opened Non Conformity at a given time. Exemple : "On the 1st february...

Hi, I am trying to work out the DAX to calculate the average time taken to fill a specific type of vacancy from my data source ‘CSD Archive’ To do this manually I would set filters on the following columns: ‘% Filled (Static)’ to 100 ‘Route’ to 1.GRS To work out the average I would then...

Hello- I am new to Power BI & DAX. I am struggling to work out how to return lowest date across two tables. I want the following rules applied If deceased date blank then end date If deceased date before end date- deceased date All else end date Format Looks like Below...

Hi Guys, I've got a question about RLS in PowerBI. My problem: When i give someone access to my reports without a role, they see all data. Is it possible to set my dataset to like a RLS only? So when someone without a specific role opens the report, they see nothing. I ask this because of...

Hi guys, I am really struggling to use PowerBI in the following setup: I have a PowerBI desktop. I Created a project where I import data from an excel file on my PC and I installed personal gateway and setup a scheduled refresh, so it will be published online also. I get to endless problems...

I have PowerBI connected to Excel data source (ie not imported but "linked"). This Excel (either can be on OneDrive business or desktop) contains a powerquery to do data transformation. The data in Excel data itself is stored in "Data" tab that resides within this Excel and does not further...

Hi all, I work at a school and got a (probably educational) powerbi pro license. I want to experiment with powerbi dataflows but cannot see the functionality in the powerbi online service. Anyone knows why? Kind regards, MrJoosten

Hi all need some help with powerbi and power query. I have an group e-mailbox with 60k+ e-mails and grows every day. I tried to import all emails to powerbi desktop, it works but its very slow 20 minutes or more for reading the box to pbi.. Every update of the query pbi runs again for 20...

Hi all, I've got an authorization issue with publishing PowerBI reports to sharepoint. As soon as i publish a PowerBI report on my sharepoint page, everyone with acces to my "report" sharepoint page and with a powerbi license has acces to that report. I want the authorization based on my...

Unfortunately I cannot connect PowerBI to Salesforce and I will need to generate reporting in PowerBI from the exports in Salesforce which are in Excel. Do you recommend creating an Excel template for which you copy and paste the data into so automatically generate in PowerBI? Or can you load...

Hi I am yet again stumped by a DAX measure. I am trying to create a measure of forecast over leadtime i.e. The cumulative forecast over the leadtime of the Product (which varies by product). The calculation works at the Product level but fails during aggregation. I cannot resolve how I use...

I have been really struggling with this for the past week. Let me explain what is it that I'm trying to do and maybe you can help: A forecast is made for 1 product only. It has a date and volume to be ordered A product can have many forecasts Each product is made out of many intermediates...

I'm trying to create a new column in Power BI Desktop which replicates a basic Excel formula which seems simple enough. The Excel formula which I am trying to replicate is in column D: =IF(B2=B1, 0, C2) So that the returned column should look like column D. I have the same data structure...

Hi All, very very new to power Bi. Can you guys help me from where I can learn easily power bi..

Hi Guys, I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change. Please help! Thanks &...

I have recently started using PowerBi. I have a question about using a date picker/slicer for all the tabs in PowerBi. I understand how to filter on a visualization and the page with the date slicer but how can I do the whole project? Also, can the date slicer be used on certain visualizations...

Hi, I am taking a shot at a real-time dashboard, I'd get a kick out of the chance to utilize the powerbi Rest API. My inquiry how does the refreshing of columns function. I have 1300 records to stack once and after that refresh 2 sections for each column at regular intervals. The main rest...

Hey everybody, I am a student at a community college in the United States, and I have just learned the basics of PowerBI by creating PowerPivot tables. This tool is super helpful, and makes Excel much more like a database application in my opinion. I just wanted to create a post to let you...