13 votes

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

Does this mean Microsoft will eventually try to deprecate SSRS? Ref: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/07/19/sql-server-2017-reporting-services-release-candidate-now-available/ No. ...
SqlWorldWide's user avatar
  • 13.2k
9 votes
Accepted

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

About the separate installer for SSRS, here's a good reason: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/ In summary, SSRS, and PowerBI Report ...
RoyceBautista's user avatar
5 votes
Accepted

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

You are absolutely free to build and distribute .pbix files by file shares or OneDrive, or SharePoint Online. Eventually this will lead to Power BI Service usage, or at least your team mates will ...
David Browne - Microsoft's user avatar
4 votes
Accepted

Can Power BI change data in the database?

The right way to approach this would be to create a separate authorisation ID (user) for this person and grant only minimally necessary privileges to it. This way the person will not be able to do ...
mustaccio's user avatar
  • 26k
4 votes
Accepted

Login Error while connecting SQL Database through Power BI?

I found resolution for this error: By default, the Encrypt connection check box is selected to signify that Power BI Desktop connects to database using an encrypted connection. If a connection to ...
CR241's user avatar
  • 1,495
2 votes

Counting rows in a table based on subtable result

select count(customer) from ( select customer from table group by customer having sum(value)<>0 ) X
LoztInSpace's user avatar
2 votes
Accepted

Minimum credentials on SQL Server to connect via Power BI Desktop

I made a test SQL user, created the test user in a Test database I created, and granted it datareader access using scripts, and this worked without an issue. Switch out the usernames and database ...
Ali Razeghi - AWS's user avatar
2 votes

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

The example schemas are now on Github. https://github.com/oracle/db-sample-schemas
Michael Kutz's user avatar
  • 4,829
2 votes

Can Power BI change data in the database?

Perhaps sufficient to protect from writes: CREATE USER 'powerbi'@'...' IDENTIFIED BY ...; GRANT SELECT ON dw.* TO 'powerbi'@'...'; And then require that Power BI login with that. You may need a few ...
Rick James's user avatar
  • 78.1k
1 vote

Querying tables that are created monthly as one table (a phone PBX)

It is generally "wrong" to split data up into multiple tables. A "single" table can PARTITIONed into multiple subtables. If it is set up correctly, you can use "transportable ...
Rick James's user avatar
  • 78.1k
1 vote

SQL Dynamic Query based on user input in PowerBI

Write the query to provide the data set you want. Then add filters and slicers in PowerBi. PowerBI needs access to the full dataset before it can filter it down. All of the filtering options you need ...
Sir Swears-a-lot's user avatar
1 vote

Create a category column or a table for each category?

Neither. Use a junction table to model a many-to-many relationship.
mustaccio's user avatar
  • 26k
1 vote
Accepted

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

I added a variable that stores the current year & month and then compare to the yearmonth column to pull the current year & month count for each Team CurrentCountPerTeam = VAR ...
Sam Johnson's user avatar
1 vote

Unable to create linked server to Power BI XMLA endpoint in SSMS

I was wondering when someone would ask that. First, why what you're doing doesn't work. The MSOLAP OleDb provider uses a .NET component (ADAL) for Azure Active Directory authentication. Using .NET ...
David Browne - Microsoft's user avatar
1 vote

Converting EAVT table into SCD type 2

I would personally get a combined set of both tables for each date and load them (and historize as SCD type 2) as if they were loaded on daily basis. So load each day separately one by one
Tomasz T's user avatar
1 vote
Accepted

DAX Calculate the sum of values for a year with start date and end date

Please call the table you listed in your example FactWorkload. Create a new table called DimDate with one row per day at least spanning the date ranges mentioned in FactWorkload if not more. Add a ...
GregGalloway's user avatar
  • 1,385
1 vote

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

If you are formatting cells based on group totals and not a row value, you need to use an aggregate and indicate the correct row group scope. In this sample, "UserName" is the name of the ...
solutionist's user avatar
1 vote

Need help installing ODAC 122011x64 so I can connect ADW to Power BI

I figured out the solution after reviewing this post. Apparently having over 2TB of free space on a hard drive causes this problem. You have to go into command prompt and create a temporary file to ...
Andrew Hicks's user avatar
1 vote

How to reference column of DAX variable?

In DAX you can't use a variable name as with tables that are defined in the model. What you can do is to use the original table names using the table variable as a filter. For instance like in the ...
sergiom's user avatar
  • 159
1 vote

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

I have succeeded in getting the Azure devops pipeline to create releases and deploy to on-prem resources (sql servers) . The overall solution was indeed to install and configure a self-hosted windows ...
PeterDaniels's user avatar
1 vote
Accepted

sp_blitzFirst Does Not Output to DB When Run as SQL Job

Moving the answer from the comments: When this happens, start by double-checking the contents of your Agent job, and make sure it exactly matches the command you're running manually. In this case, ...
Brent Ozar's user avatar
1 vote
Accepted

How to extract multiple key value pairs into distinct columns

This can be achieved using a few lines of Power Query: Remove outer brackets ("[" & "]") using Table.ReplaceValue Merge [Primary] & [Secondary] columns using Table.AddColumns & Text....
solutionist's user avatar
1 vote

Login Error while connecting SQL Database through Power BI?

Go to File > Options and Settings > Data Source Settings > (select your data source) > Edit Permissions > Edit > Database, and enter here your User name and Password
Francesco Mantovani's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible