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: 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: 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...

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

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 ...

Filled map

Hi, I want to try to create a filled map chart. I have my data : Country, Year, number of things. I click the map icon, I select the country field (if I drag the field into "Legend" I can see my co...

Access Sharepoint InfoPath XML form library content using SharePoint Folder

I have a Sharepoint forms library containing several hundred InfoPath forms (XML files).  They all share the same schema.   I downloaded about 50 files to a local folder, and success...

Rookie question: Setting up a calculated column

Hi, just setting up my first report.  So far so good but...   In TableA I have a Revenue figure and Currency Code, in TableB I have a Currentcy Code and Exchange Rate to EUR.   I'v...

Re: Dashboard and Report showing when publishing a content pack

@sbstern If I understand you correctly, you aren't doing anything other than publishing the new PBIX to the Service and it is automatically adding the dataset and reports to your content pack?.....

Request demo