power

Power Bi is not displaying content from the office planner.Our requirement is to office planner content in Power Bi Page.We are using tile with link set to office planner however we end up with error message "Content cant be displayed in iframe".Is therr any other method for dislaying the...

I’ve been using Power Query (2013) to import several Csv files, process them, run a couple of merges and dump the final tables in worksheets in excel None of the files are very large (less than 200 rows). I’m using staging queries to pull in the data and then separate loading queries to output...

Hi All, Can you please share some good websites which you've come across to learn Power Query? I'm finding a lot of excel websites, but they hardly cover Power Query. I currently own the following books: 1: M for Data Monkey and 2: Collect, Combine, and Collect, Combine, and Transform Data...

I'm new to Power BI/Power Query and need some help. I connected Power BI to my database server and there is a field that I need to convert to date/time. The database stored the minute as the number of minutes since 24:00 on 31/12/1900. For example, 00:01 am on 01/01/1901 =1. I need to...

Reference :Help in Easily Downloading new images into Power Bi for chartinfo graphs or find images that can be easily downloading to use in Power Bi Hi there I a new to Power Bi ... so be gentle with me :) I have download images in my picture but when I downloadthem into power bi when I...

Hi all, having this issues for quite a while a am not able to resolve it. When i use pivot table dates are not being recognised as dates. I consider myself power user and daily reconcile millions of rows of data, but this little issues is quite annoying. Particularly annoying is that a list...

Book1ABCDEFGH1VendorOrder RefCreation DateTotal PO AmountPO CurrencyDocumentPayment AmountPayment Date21000010034B111111112/24/2018191.78USD5100006334203.841/17/201931000010034B111111112/24/2018191.78USD00.0041000010034C11111112/4/2019400.00USD00.0056Desired output:78VendorOrder RefCreation...

Hi Guys, I have installed the Microsoft office professional plus 2016 on my personal computer (with a subscription of course) and i signed for the insider. My question is: Is it different from the office 365 pro plus insider?? Curious, because i am using certain keyboard shortcuts like Alt+B+M...

Hello, I've been using Excel for years but have recently been seduced by the appeal of Power BI as a means of providing more 'visually friendly' reports for other users to view and analyse. Whilst I can generally get Excel to do what I want to do (possibly through horrendously inefficient...

Good morning; I receive a few text files that needs to be imported and parsed. I wanted to automate this process but my company does not allow us to use VB. Is there a way to automate this process, especially the file navigation, using power query (and not VB)? Thanks

Hi All, I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format. Here is the my requirement. Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make...

Hi All, I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format. Here is the my requirement. Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make...

Book1BCDE1InvoiceDateAmountBooked2M012103219-Mar-19101.48BookedCoynesCell FormulasCellFormulaE2=IFNA(IF(MATCH("*"&B2&"*",'[22.07.2019 Consolidated.XLSX]Sheet2'!K:K,0)>0,"Booked","Not Booked"),"Not Booked") Hello, I would like to load this table into power query. When I go to Data ribbon ->...

I set up external connections to excel workbooks to load data into power query (went fine). I decide to test the refresh feature by changing some things in the source data. It won't refresh -ever. Any idea what he problem is. What's the point of having a refresh feature if the connection...

Hello I've hooked an excel file up to a SharePoint folder on my o365 machine no problem. I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in. The add-in doesn't have 'From SharePoint Folder' available under 'From File'...

My source data is in Power Pivot, pulled directly via SQL, and I have measures that calculate over 20 days, 10 - 20 days or under 10 days. These are based on a calculated column that categorises each line accordingly (from a Task age column). I want to create a pivot table that shows max task...

I have a power query setup that imports tables from all excel files in a folder. Is it possible to have a column that contains a link to the original excel file? [I have this working in a regular excel table using the hyperlink function (which uses the customer name to get to the correct...

Hello, I was looking to do a Power Bi but the excel file that I am using has data in an unfriendly way for Power Bi Current data structure <tbody> 2014 2015 2016 Measure #1 1 2 3 Measure #2 2 4 6 Measure #3 3 6 9 </tbody> Desired Structure <tbody> Year...

Hi, I am having trouble converting an excel formula into a power query statement. The formula is =VALUE(IF(ISNUMBER(VALUE(MID([DocNum],6,1))),[DocNum],LEFT([DocNum],5))) I have it in a custom column, but would like it to ideally be used as a formula in the [DocNum] column in power query if...

Hi All, I'm experiencing a problem where power query slowed down after I merged two tables. Since the merge, each time I do a step, it appears its recalculating or refreshing something in the back ground. the refresh stops when it reaches 120MB which takes about 5 to 10 minutes. So basically...