Skip to main content
20,652 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
4k views

Background I need to create a Power BI report/dashboard from data that is locked up in a tightly firewalled PostgreSQL database. Connecting Power BI directly to the DB is not an option. I can however ...
PerryW's user avatar
  • 1,436
2 votes
1 answer
462 views

I have an Azure Stream Analytics job outputting to PowerBI - outputs are present and the data set is present in PowerBI - however, the graph is not live as I have to manually refresh the page to ...
Raymond Dillon's user avatar
  • 307
7 votes
3 answers
614 views

Is it possible to filter data based on the user who login to the dashboard? How to get the user details on login? Also is dynamic data filtering possible in power BI? If so please give some useful ...
Dhivya Sivaraman's user avatar
  • 71
11 votes
1 answer
3k views

We have large csv files in Azure Blobs that we want to report on. It looks like with some M, we can use Power BI desktop to connect to the blobs and start to report on them. We want to automate this ...
Michael Blake's user avatar
  • 2,167
1 vote
1 answer
478 views

I have set Azure Stream Analytic job output as Power BI. But I am getting warning in the analytic job that System.Object type which is not supported by PBI service. Also I am not able to see any ...
Midhun Murali's user avatar
  • 2,151
1 vote
1 answer
672 views

The following measure works as I want it: Heltidsanställda har börjat:=CALCULATE((COUNTA([Anst fr o m]);FILTER(ALL(tDatum[Datum]);tDatum[Datum]<=MAX(tDatum[datum]))) But when I want to weight each ...
user1283776's user avatar
  • 22.2k
0 votes
1 answer
856 views

Ideally, I would like to calculate the cycle time of the whole value stream represented by Product Backlog Items in Visual Studio Online via Power BI. (I would then love to get time per status, i.e. ...
Fenton's user avatar
  • 253k
2 votes
2 answers
3k views

I am trying to setup a data set in Power BI which can be refreshed on a need basis or scheduled to refresh. I am uploading an excel workbook which has a power query. the power query is connecting to ...
shamanth Gowdra Shankaramurthy's user avatar
  • 1,015
0 votes
1 answer
159 views

I am fairly new to DAX / PowerPivot but have built a nifty Sales Dashboard which is working well. Once combined with the PowerUpdate utility and Office365 PowerBI we will have a awesome solution. I'm ...
ben corke's user avatar
  • 43
0 votes
1 answer
3k views

We are trying to perform a Utilization % calculation in DAX and I cannot figure out the forumula. Here's the setup: Table images are here: http://imgh.us/dax.png Table 1: There is a [timesheet] ...
rocketfish's user avatar
  • 19
1 vote
1 answer
1k views

I have set up an on-premises Tabular model using Roles to filter data by rows. When logging on locally and using Excel this works great and filters as intended. Then I use the Power BI Analysis ...
Espen's user avatar
  • 11
0 votes
1 answer
172 views

I have an Azure SQL database with several tables, including a Date dimension (D_Date). When I connect to it from PowerBI.com and then try to create some simple visualizations, I get the error "We ...
Kelly's user avatar
  • 1,014
1 vote
2 answers
2k views

FINAL EDIT: The answer has been found. It was a dependency issue. Read answer below. I'm working on a program that eventually should push data from an SQL server db real-time to our power BI report. ...
Paternostro's user avatar
  • 113
1 vote
1 answer
253 views

Is it possible to include more than one input source in stream analytics? I want to output different columns into the same output , however, it does not allow me to use the same output name. This is ...
Aditi Mittal's user avatar
  • 11
0 votes
1 answer
881 views

I currently have a suite of about 25 SSRS reports. Some are very high level and from there you can drill into more detailed reports. Some of the high level reports are basically simulated pivot views ...
Dave Sapelak's user avatar
  • 3
0 votes
3 answers
354 views

Is there a way to get a Microsoft Power BI Designer data model into Excel to work with in Powerpivot?
analytic_banana's user avatar
  • 25
1 vote
1 answer
189 views

I am currently able to use Power View to view, filter, and highlight my data. However I haven't figured out a way to link my table rows to the data source (i.e. tables in other tabs of the Excel ...
tennisbuddy's user avatar
  • 35
0 votes
1 answer
78 views

I'm outputting a Stream Analytics job to PowerBI.com. It successfully sends the first 11-100 messages just fine, but after which it fails. In the operational log it says the operation "failed to send ...
Phuc H Duong's user avatar
  • 501
1 vote
2 answers
2k views

I am currently doing a computer science degree. As part of my industry project for my university, I am developing a BI solution for a client. Having gone though the project I'd like to develop it ...
Sharingan's user avatar
  • 333
0 votes
2 answers
163 views

I am sending data from Stream Analytics to powerbi. Most of the time it works fine but from time to time I upload large amounts of data for test purposes. I notice that my SU utilization is 100% and ...
Gökhan Kurt's user avatar
  • 531
1 vote
1 answer
4k views

Is it possible to show the Maximum of date time value in Powerbi as you can do for integer fields? I want to see in a tile last time an event received and the value for that sensor event.
Gökhan Kurt's user avatar
  • 531
0 votes
1 answer
109 views

I have 2 copies of the same SharePoint online site: different name, different site collection, but with the same lists, libraries..., I want to reuse the same Excel for the two sites. I can’t change ...
Alba Pardos's user avatar
  • 1
0 votes
1 answer
504 views

I am sending data from stream analytics to power bi. I have created 4 different outputs that are referencing same powerbi subscription and same dataset name but different table names. I am writing to ...
Gökhan Kurt's user avatar
  • 531
2 votes
3 answers
12k views

I am looking for a formula to calculate the number of weekdays/business days between two dates in power pivot. I do the same in T-SQL using the following query DATEDIFF(dd, Date1, GETDATE()) - (...
perplexedDev's user avatar
  • 827
1 vote
1 answer
671 views

In one end I am sending a single table to power bi from stream analytics using the query SELECT DeviceId, SignalCode, MeasurementTime INTO receivedsignalcodes FROM inputeventhub And on the other hand ...
Gökhan Kurt's user avatar
  • 531

1
…
410 411
412
413 414