Power BI Support

Search

Re: best way to push data from excel to sql server ..no of rows keep chaning in sheet ? any ideas

Hi @shashank, Adding to other post, you can also use other methods to move data from Excel to SQL Server. a. Configure Excel workbook as a linked server in SQL Server and then import data...

Re: Vizion Solutions NBA Analysis

Very nice!   how did you do the team card? how did you embeded the team logo?    Thanks; Andrew

Re: Only require a selection in the report filters

Yes u r correct. this option only available on Page level. it is not appear in Visual level or REport level.    The resaon behind this is , It was added for Cortana and Q&A to find th...

Re: Summarizing data

Hi,   I think you could use CALCULATE or SUMMARIZE to do this. Will all the values in hosp_hours all be the same per each patient? So will pat1 always have 24 hours?   http://www.w...

Re: Sheduled updates fail... but manual succed

Hi @v-caliao-msft,   Thank you for your reply.   I am running the scheduled updates through the personal gateway (installed on a virtuel server), and it indicates to be running fine. Th...

Re: If Statement in DAX

Using this is giving me an error that "A table of multiple values was supplied where a single value was expected". 

Re: Only require a selection in the report filters

  @parry2k, @Baskar   Sorry, I would like to select only one filter item, but when I include a report filter it does not display the option to allow only one item to be selecte...

Running total / cumulative Sales

  We have a requirement to create some Running totals in Power BI, we tried several measures but the results were not as expected. how can we achieve this in Power BI?   Solution to thi...

Re: Refresh connection to simple Excel in OneDrive

Hi @mshparber,   I have tested it on my local environment, we cannot reproduce this issue.   Regards, Charlie Liao

Re: Can not Sign in in PowerBI desktop

Hi @pinikr,   What do you mean about the "MSFT privet account"? Like @microsoft.com?   To sign in in Power BI desktop, we need to sign up a account firstly. You can take a look at t...

Re: Weekly Report, Year on Year - Last 8 next 4

hi @CheenuSing,   My date table is fairly generic with week number calculated using WEEKNUM( 'Date'[Date], 2 ). I have added a week table -image below- joining on the week number so...

Re: No way to export data from PBI above 30 K rows ??

Well Frank everybody's requirement are ofcourse different. I truely enjoy the ease of use in creating a good visual, but most often in my profession the visuals are used to monitor the overview and t...

Re: Get reports to company private web

Thanks, Is there difference between https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/   and Power Bi embedded?   I read Power Bi embedded is for pu...

Re: Value selected in the filter

am not getting what u exactly want to achieve . okay for my assumption.   If u select some value in slicer do u want to get that selected value in measure ? if yes try this.     C...

Re: PowerBI Spark Direct Query Issue

Hi @Girish, When I connect to Spark cluster using DirectQuery mode in Power BI Desktop, I can reproduce your issue that Publish button is disabled. Once I upload the PBIX file to Power BI Servi...

Re: end of month in selected dates

No Need date table dude , u go with same date column which u have in your table .   That will work 

Re: SAMEPERIODLASTYEAR with filter on month

@jsondervorst Lets start with some smaller steps and questions. My understanding is that you want to look at ytd, mtd, yoy, and mom. First, lets calculate a total. I genearlly build my calculations...

Re: slicer based on columns

Hi @BetterCallFrank,   Thanks for the reply. But the 2 tables are dynamic tables which I am creating form the main table based on different logics for year, sales and units,  so I ca...

Re: Google Analytics time duration formatting issue

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/   Duration is the data type used when we first import our data and can view it as a type before we load the data. ...

Can not Sign in in PowerBI desktop

Hi In the new version of PowerBI Desktop - sign in only allowed for Work account or school account.   I am working only with MSFT privet account - what can i do?

Re: Can someone tell me how to use the Workbooks section in Powerbi.com?

Hello I use several reports in Excel using queries to databases. Then I upload then to powerBI and schedule them. To upload, go to add files from sharepoint or OneDrive. Regards Rodrigo

Re: previous month not working with hierarchy slicer

Hi Giorgio, give this demo PBIX a look, i think it works the way you want, the measures work with dates and date hierarchies:   #Cust LastDate = CALCULATE( SUM( CntCustomers[CntCustomers] ...

Re: previous month not working with hierarchy slicer

it works only when i choose date. if i choose date hierarchy and select february it does not work. i use hirerachy slicer custom visual. maybe thats the problem. is there any other way to use hiera...

Re: Get data from web not showing table

https://beta.fec.gov/data/elections/president/2016/   From the above URL, I have copied contents of the first table (changed table display settings to 100 results per page and copied all ...

Request demo