Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators

Questions tagged [powerbi]

The tag has no usage guidance.

15 questions
info Newest Frequent Votes Active Unanswered
2
votes
1answer
35 views

Counting rows in a table based on subtable result

Sample data: -------------------------------------------------- | Customer | Value | -------------------------------------------------- | A | 5 ...
0
votes
1answer
54 views

How to get Kerberos working against a named SQL Server instance in Power BI Report Server?

I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing ...
1
vote
0answers
47 views

Getting MAX of AVERAGE measure (Power BI/DAX)

I am stumped. I am calculating an average of products sold per location. Then, I am using AVERAGEX to calculate that average for each sales associate. But how do I find the MAX of that average and ...
0
votes
2answers
72 views

First Responder Kit Power BI Dashboard - New Databases

With the PowerBi and sp_blitz scripts running in a scheduled task I can get the great dashboard and reports. However when I add a new database to the server they don't show up in the reports later ...
0
votes
1answer
35 views

Business Intelligence for developers

I'm a developer with apps backed with SQL databases. I want to give my CEO access through BI self-serving tools such as PowerBI or Tableau. My issue is that the affordable tools all seem to require ...
1
vote
0answers
69 views

Auth failing when using Devart ODBC connector to mLab

I'm trying to connect PowerBI to a mLab-hosted Mongodb instance. I first tried installing the MongoDB BI-connector, but after installing it didn't show up on the drivers list in Windows ODBC manager (...
0
votes
0answers
16 views

Extract max of value in Fact table using date filter

In my Data warehouse, there are Dim date and Dim City and a Fact table which at the end of each month logs the population of each city, I have a problem to calculate max population of each city in a ...
2
votes
2answers
207 views

Is it possible to host pbix and rdl files on the same report server instance?

Just upgraded an existing instance of SQL Server 2014 to 2016. That instance has an instance of Reporting Services installed. My end goal is to connect Power BI Desktop (March 2018) to my existing ...
0
votes
1answer
37 views

Best approach to calculation problem

I am re-developing an application that has been running on Excel. One of the reports I need to recreate (which will be published in Power BI and needs to be a direct query) is as follows; Column "...
2
votes
1answer
685 views

Minimum credentials on SQL Server to connect via Power BI Desktop

Note: This is not a Power BI issue, this is a DB credential issue. In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access. I have one User that is ...
1
vote
1answer
27 views

How to relate LatLong and State columns on PowerBI

I have two separate tables, one with latitude and longitude columns (for locations in the USA), and the other with the US state abbreviation (TX, AZ, CA, etc). Is there a way to count the number of ...
9
votes
2answers
1k views

Will SSRS be extinct soon, and PowerBI the new model?

I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft ...
1
vote
0answers
189 views

Error while connecting to PowerBi

I am trying to connect PowerBi to a local SQL Server instance. It has previously worked with a direct Windows Authentication. I tried changing it to a SQL Server Authentication. No luck. I have ...
1
vote
0answers
67 views

Making a KPI table in SQL or with dax?

I am going to make a KPI table, however I've yet to decided where to make it. In essence its going to show weekly numbers derived from our customer database. *Weeknumber *New users (users with ...
0
votes
2answers
8k views

Login Error while connecting SQL Database through Power BI?

I get the error message displayed in Power BI Online when using an enterprise gateway connected to an on-premise SQL Server Unable to connect: We encountered an error while trying to connect. ...