Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [powerbi]

50 questions
14
votes
2 answers

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 will eventually try to deprecate SSRS? Should our…
user129291
4
votes
1 answer

Power BI on-prem data gateway for Azure devops pipeline?

I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is there a way to make that work, or do I need…
PeterDaniels
  • 141
  • 6
4
votes
2 answers

Power BI DESKTOP licensing - is it really free to share pbix files?

The Power BI Desktop app for Windows is free, which is great. However, the Microsoft site is loaded with talk of licensing to share/view Power BI content. Is that only for their hosted Power BI SERVICE? I want to create reports in Power BI Desktop,…
SomeGuy
  • 2,053
  • 8
  • 35
  • 48
3
votes
1 answer

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 a "sysadmin" under the Server Role and that works.…
hurleystylee
  • 133
  • 1
  • 5
2
votes
1 answer

SQL Dynamic Query based on user input in PowerBI

I am pulling data from inSQL using the SQL Query below: SET QUOTED_IDENTIFIER OFF SELECT * FROM OPENQUERY(INSQL, "SELECT DateTime, [X],[Y], [Z], [A] FROM WideHistory WHERE wwRetrievalMode = 'Cyclic' AND wwResolution = 1000 AND wwVersion =…
Felix Silva
  • 21
  • 1
2
votes
0 answers

How to configure the client certificate in Power BI desktop to authenticate with mutual TLS

I am trying to connect to a private data source from Power BI desktop. Data source has its own trusted root authority. I created my personal certificate and private key signed by this root CA. I configured the PFX file of my certificate in…
Parth_patel
  • 21
  • 3
2
votes
1 answer

Where can I find SQL Developer Database examples (scripts) to add data to practice?

Where can I find SQL Developer Database examples (scripts) to add data to practice? I require SQL scripts that will add tables and data on those tables in order to practice with Power Bi.
Rodolfo Villalta
  • 21
  • 1
2
votes
2 answers

Counting rows in a table based on subtable result

Sample data: -------------------------------------------------- | Customer | Value | -------------------------------------------------- | A | 5 …
user169728
  • 21
  • 1
2
votes
2 answers

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 report server. I've downloaded and installed Power…
user9666467
  • 21
  • 1
2
votes
2 answers

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. Details: Microsoft SQL: A connection was successfully…
CR241
  • 1,565
  • 3
  • 18
  • 32
1
vote
0 answers

PowerBI Data Modeling: Modeling with sub-dimension and sub-facts

We collect test data from network tests. There is common dimensions and facts for all the different tests, But there are also some facets of the dimensions and facts that are unique. If this was an OODB I would created a super-class with all the…
Dr.YSG
  • 409
  • 1
  • 4
  • 15
1
vote
1 answer

How do I write a Dax statement that returns the current counts whenever I filter for a TEam

Below is my sample table and I'd like to write a Dax statement that returns the current count whenever I filter for Team A or B. Ideally, the current count per team would be on a card in power…
Sam Johnson
  • 21
  • 6
1
vote
3 answers

Can Power BI change data in the database?

A colleague approached me with a request to install Power BI for him. As I understand it, this software creates various graphs and reports based on data from the database. In this regard, I have a question. The database to which the user asks to…
RoyalGoose
  • 115
  • 4
1
vote
0 answers

Power BI Capacity/Tenant/Gateway - where does the data sit and flow?

I have a scenario with Power Bi Premium where it has been very difficult to get a straight answer or find information that answers the question. Our Power BI tenant is located in Australia, our Power BI Premium capacity is located in Switzerland,…
jezr
  • 11
  • 2
1
vote
1 answer

SSRS - : How to make a conditional formatting for matrix by group?

I currently have a report produces a matrix, displayed per user group. (1 user group per page, with 35 user groups/pages) I want to highlight the row in pink in this condition: =IIf(Fields!CountFailures.Value>=1,"Pink","White") However, it is not…
user7821021
  • 11
  • 1
1
2 3 4