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.
...
- 13k
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 ...
- 151
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 ...
- 45.3k
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 ...
- 24.8k
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 ...
- 1,479
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 ...
- 76.3k
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
- 788
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 ...
- 7,478
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
- 4,774
1
vote
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 ...
- 21
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
- 11
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 ...
- 1,385
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 ...
- 76.3k
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 ...
- 3,185
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 ...
- 341
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 ...
- 111
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 ...
- 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 ...
- 141
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, ...
- 42.6k
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....
- 341
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
- 1,454
Only top scored, non community-wiki answers of a minimum length are eligible