You can’t have a shared data source? What if you are switching environments from Dev, Test, Prod and you have over a 100 reports? You have to manually change every reports data source!? This can be dangerous ...
Hello Patrick, Are any complete courses paid or free on Power BI from scratch to advanced from your end? I check videos based on what I want to do but I always have some loophole and would like to capture the complete Power BI operations.
Hi Patrick, I have a parameter and in the query, that parameter will have duplicate values in that column. When I run the report it shows the duplicate values in the drop-down list. Will be great if someone can guide me to resolve this. Thanks and regards.
When you show that you can create reports in Visual Studio, you have the preview button available to test the report. I am trying to create a report in VS2017 Pro am I do not have the preview tab/button available. Do you know how to enable this or can you point me in the right direction? Thank you. Nice video series BTW.
The preview button is only in Report Builder. Visual Studio, you need to just run the report. You should be able to right click on the RDL file and run that report from Visual Studio.
Hi, Patrick! In your Connection Type dropdown (2:30), I see you have quite a few more options than I'm seeing for myself! How did you add ODBC? Right now, I only have Microsoft SQL Server, Microsoft Azure SQL Database, Microsoft SQL Server Analysis Services, Oracle Database, Enter Data, and TERADATA. I'm able to connect via ODBC in PowerBI but not PowerBI Report Builder. Any help would be appreciated!
Hi Patrick, I downloaded RDL files from your link, but can't open them with report builder and got error msg "Failed to open report - DTD is prohibited in this XML document." Is there a way to fix it? Thanks
I have no idea why my pbi report builder is not connecting to the ms sql server on prem that I set up locally using .\ as advised. anyone have any idea how to debug this? thanks. I added ms sql server onto firewall and also enabled TCP/IP, but nothing helped.
Hi Patrick, Appreciate you creating videos on paginated reports. Are there any resources you can advise where one can go and see good examples of paginated reports. While Power Bi gave the modern look and feel, we are struggling to find good examples of paginated reports - would you be share resources where we can experience a good variety of modern looking paginated reports? (just like Power BI has data stories gallery).
Why Microsoft doesn't use the same easy process to create reports as in Microsoft Access Reports instead this so complicated process to create Paginated Report, Access and Power Bi are based on SQL Code
Patrick - Thanks for putting this up. I thought the magic was that SSRS reports would be able to connect to our Power BI Datasets. With them supporting XMLA endpoints, shouldn't it be possible? I'd like to use the Power BI Dataset as my one version of the truth and give my users the flexibility to present those reports either as interactive dashboards (Power BI) or paginated reports (SSRS). Is that the direction this is heading, or will SSRS and Power BI reports pull from different places in the Power BI Service?
It isn't yet. It will be coming. Check out the following doc for the current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi. It just came out in public preview. There is still work to do.
This requires my laptop to be on. I'm running a postgres server on google and i just want it to refresh how do i do that? It's actually kind of ridiculous that is't not easy to do. When i create the reports on Power bi desktop i use odbc,once i publish it so i can share. It becomes messy. It needs my laptop to be on. Why isn't it straight forward to just enter credentials and it connects.
Hello Patrick, When I right click on report builder to add the Data Sources, I can't see the option to add Power BI dataset connection. Is that something I have to enable some where, can you please help. Appreciate in advance.
Hi Patric , i am using odbc data source for connecting to snowflake database. I believe it works on direct query mode as each time query is fired against database . Am I correct ? I don't have link which supports that. Do you know anything about that ?
Is there a way we can create paginated report, attaching the fields on text box instead of a table. If so, can you send me an example. Most of the videos use tables. What i need is a paginated report with separeted fields? Can we do that on PBI Reports? Like a form.
Hi., I am using power bi measures in paginated report. I am getting wrong values in totals field In paginated report. I am using table view and for each column I am calculating totals at the top.
I am having trouble adding a PowerBI Dataset as a Data Source. Seems straight forward, but I seem to not be able to authenticate to the report when I try to add the dataset even though it shows. Any insight or perhaps a video update?
Hi, I used my Power BI data set as data source in the report builder. I had 2 tables linked by an ID in my PBI data set but this connection didnt flow to the report builder app. How can I fix this? Thanks!
Are there any benefits using this instead of Visual Studio? I only see disadvantages as you don't have source control and no support of shared datasets.
Can you also show us How to create a date parameter (as a calendar) from the dataset in the Power BI report builder? for some reason, it would not recognize it as a date field. Or in other words, If I have a measure which is filtering upon date slicer, How will this work in Report builder?
Heyy patrick first i wanna say i love your videos n they are a gr8 help since im a new power bi learner But i wanted to ask u how can i dynamically extract a column with distinct values from an existing column of a tablein power bi , i hve been unable to do it so i really need your help.
Hi Patrick, Is there any way to pick up the Username() of the logged in user, so we can pass that to our Stored Procedure and implement some sort of RLS?
You probably found it by now, but try out the Built-in Field "User ID". Be aware it returns different results when running On-prem vs. the Power BI Service. On-prem returns DOMAIN\UserName, and when running in the Power BI Service it comes across as the User Principal Name and will look more like UserName@domainaddress.com. I ended up building a SWITCH expression that used InStr to look for the \ or the @.
It is a Premium only feature from the Power BI service perspective. Some of this is due to technical limitations of how SSRS was architected. You can still use paginated reports in SSRS or Power BI Report Server.
So can you connect to a Power BI Data Model? It did not seem to be an option. Will that be available at some point. Ideally, I'd like to be able to link the paginated report to a PBI report where all the slicer options can be ported to the paginated report and it prints out using the pre-filtered Power BI data set.
Not yet. It is coming though. Check out the following doc for a list of current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi
Patrick, nice meeting you at MBAS last week. I believe you did a demo on connecting PBI Report Builder desktop to PBI Service - a existing dataset on premium workspace. Do you have that sample by any chance? thanks. BTW - Enjoy your session especially giving Adam hard time :-)
I think this is the same as the old SSRS paginated reports, just that now its all in one platform, and eventually the Power BI & Paginated reports will be better linked, I guess. I was hoping Power BI features would take over or handle all features of paginated reports.
Hi Patrick, love your videos. I still have a big question I have not been able to answer. Can I execute the paginated report trough an API, sending the parameters and getting back a PDF? Thanks in advance!
I have tried to upload my RDL files only to get errors, which say to call support. I have tried simple to complex, always the same error.i know this is in preview but I was hoping to try it with some existing reports. All were created with report building and have SQL Server as data source. Looking forward to next video! Love the videos, thanks for all your help here and at your monthly live sessions!
Hi Russ, do you have the paginated reports capability turned on for the workspace you’re looking to upload to? Do you have subreports or any clickthru actions in your reports? Please let me know!
I will check to make sure it’s turned on with our admin. I have tried with basic reports, no click through all the way to reports with click through. I assumed we had it turned on but that may be it. Thanks!
As of right now, Paginated reports don't support using Power BI datasets as a data source. It has been stated that will be coming as it gets closer to GA, or maybe shortly after. It is still Preview currently.
You can’t have a shared data source? What if you are switching environments from Dev, Test, Prod and you have over a 100 reports? You have to manually change every reports data source!? This can be dangerous ...
Hello Patrick,
Are any complete courses paid or free on Power BI from scratch to advanced from your end?
I check videos based on what I want to do but I always have some loophole and would like to capture the complete Power BI operations.
Hi Patrick,
I have a parameter and in the query, that parameter will have duplicate values in that column. When I run the report it shows the duplicate values in the drop-down list. Will be great if someone can guide me to resolve this.
Thanks and regards.
Thanks Patrick for the Dummies like me. Hugs from Brazil :)
Most welcome! thanks for watching! 👊
Hello patric
Please make a video on how to pass multiple parameters to stored procedure in sql server database
Can we connect power bi dataset which has been created using import mode.
When you show that you can create reports in Visual Studio, you have the preview button available to test the report. I am trying to create a report in VS2017 Pro am I do not have the preview tab/button available. Do you know how to enable this or can you point me in the right direction? Thank you. Nice video series BTW.
The preview button is only in Report Builder. Visual Studio, you need to just run the report. You should be able to right click on the RDL file and run that report from Visual Studio.
Great quick video
Hi, Patrick! In your Connection Type dropdown (2:30), I see you have quite a few more options than I'm seeing for myself! How did you add ODBC? Right now, I only have Microsoft SQL Server, Microsoft Azure SQL Database, Microsoft SQL Server Analysis Services, Oracle Database, Enter Data, and TERADATA. I'm able to connect via ODBC in PowerBI but not PowerBI Report Builder. Any help would be appreciated!
@guy in a Cube, I am having the same problem. Any idea?
How can we set parameters for a paginated report that uses shared datasets?
Hi! It could be possible to add the link of the video about Azure Sql that you have talked at the beginning of the video? Thanks!
Hi Patrick,
I downloaded RDL files from your link, but can't open them with report builder and got error msg "Failed to open report - DTD is prohibited in this XML document."
Is there a way to fix it?
Thanks
I have no idea why my pbi report builder is not connecting to the ms sql server on prem that I set up locally using .\ as advised. anyone have any idea how to debug this? thanks. I added ms sql server onto firewall and also enabled TCP/IP, but nothing helped.
Hi Patrick, Appreciate you creating videos on paginated reports.
Are there any resources you can advise where one can go and see good examples of paginated reports. While Power Bi gave the modern look and feel, we are struggling to find good examples of paginated reports - would you be share resources where we can experience a good variety of modern looking paginated reports? (just like Power BI has data stories gallery).
There isn't a gallery like there is for Power BI. I'm not aware of any resource for that. :( maybe someone else can comment on something?
is anyone using or know if you can PowerBI datasets in report builder?
Why Microsoft doesn't use the same easy process to create reports as in Microsoft Access Reports instead this so complicated process to create Paginated Report, Access and Power Bi are based on SQL Code
Can we connect to our dataset to create paginated reports
Patrick - Thanks for putting this up. I thought the magic was that SSRS reports would be able to connect to our Power BI Datasets. With them supporting XMLA endpoints, shouldn't it be possible? I'd like to use the Power BI Dataset as my one version of the truth and give my users the flexibility to present those reports either as interactive dashboards (Power BI) or paginated reports (SSRS). Is that the direction this is heading, or will SSRS and Power BI reports pull from different places in the Power BI Service?
It isn't yet. It will be coming. Check out the following doc for the current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi. It just came out in public preview. There is still work to do.
can you pass a parameter to the query, when using powerBI as a datasource?
Can we create parameters that auto select things? Such as present date? or Present date -7?
How to execute a PBI paginated report when any one data source is not accessible
Q: can you show me how to publish.rdl files to power BI
This requires my laptop to be on. I'm running a postgres server on google and i just want it to refresh how do i do that? It's actually kind of ridiculous that is't not easy to do.
When i create the reports on Power bi desktop i use odbc,once i publish it so i can share. It becomes messy. It needs my laptop to be on.
Why isn't it straight forward to just enter credentials and it connects.
Hello Patrick, When I right click on report builder to add the Data Sources, I can't see the option to add Power BI dataset connection. Is that something I have to enable some where, can you please help. Appreciate in advance.
Hi Patric , i am using odbc data source for connecting to snowflake database. I believe it works on direct query mode as each time query is fired against database . Am I correct ? I don't have link which supports that. Do you know anything about that ?
Is there a way we can create paginated report, attaching the fields on text box instead of a table. If so, can you send me an example. Most of the videos use tables. What i need is a paginated report with separeted fields? Can we do that on PBI Reports? Like a form.
Hi., I am using power bi measures in paginated report. I am getting wrong values in totals field In paginated report. I am using table view and for each column I am calculating totals at the top.
Hi Patrick how to achieve MAT, MAT LY, YTD and YTD LY in Report Builder ..pls suggest
I am having trouble adding a PowerBI Dataset as a Data Source. Seems straight forward, but I seem to not be able to authenticate to the report when I try to add the dataset even though it shows. Any insight or perhaps a video update?
Hi, I used my Power BI data set as data source in the report builder. I had 2 tables linked by an ID in my PBI data set but this connection didnt flow to the report builder app. How can I fix this? Thanks!
Can Power BI Data Flows be used to create paginated reports in Power BI Report Builder?
Hey Patrick, A year has passed, any plan to release the use of a shared datasource. Deployment of several reports is a nightmare without this feature.
Are there any benefits using this instead of Visual Studio? I only see disadvantages as you don't have source control and no support of shared datasets.
Any idea how to connect Power BI Paginated Reports with ODBC Support?
How about the Data source from excel? is not possible on Power BI Report Builder?
Can we call data to power bi using oracle database by writing stored procedure in advanced SQL statement
paginated report: can I change the data source for a similar data source to keep the same report?
Can you also show us How to create a date parameter (as a calendar) from the dataset in the Power BI report builder? for some reason, it would not recognize it as a date field. Or in other words, If I have a measure which is filtering upon date slicer, How will this work in Report builder?
Fantastic stuff, thank you. Please do a walk-through of a connection string for a SharePoint Online List?
can please share credentials of the file which you have shared on github
Hi, I want to use Excel as my data source. Can we connect Report Builder to Excel?
Excellent video. But the best is yet to come in the next videos.
Lots of good stuff coming. Thanks for watching Andre!
Hi Patrick,thanks for that. any pointer to get datepicker for from date and to date in paginated report.
this guy started a company since microsoft employe?
Heyy patrick first i wanna say i love
your videos n they are a gr8 help since im a new power bi learner
But i wanted to ask u how can i dynamically extract a column with distinct values from an existing column of a tablein power bi , i hve been unable to do it so i really need your help.
Cool
HEY !! Thank you for the informative video By the way is it possible to apply page break on a Column chart
.?
Shared connections is already supported today?
Could this report publish to Power BI Report Server On-Premise?
hello does those type of reports supports data gateway integration?
Hi Patrick, Is there any way to pick up the Username() of the logged in user, so we can pass that to our Stored Procedure and implement some sort of RLS?
You probably found it by now, but try out the Built-in Field "User ID". Be aware it returns different results when running On-prem vs. the Power BI Service. On-prem returns DOMAIN\UserName, and when running in the Power BI Service it comes across as the User Principal Name and will look more like UserName@domainaddress.com. I ended up building a SWITCH expression that used InStr to look for the \ or the @.
Can you please help with scheduling gateway refresh of paginated reports ?
You don't schedule a refresh on a Paginated report. You schedule refresh on a dataset or dataflow.
I was trying to follow along locally, but don't have a login or password for the demo data :(
You would need to have the AdventureWorks database in some database server. Then use the credentials for the server you put it on.
So this will not be available in Power BI Desktop...? Seems like another Access or SSRS retread
Yeah - just SSRS tagged onto Power BI. Good for the Power BI Service to show list reports, as well as just visualisations.
Hi! Which reproduction list would you recommend to get first steps into Power BI?
Will this be available in Pro or ONLY Premium Capacity? I need this functionality, but I won't be able to use it if it's Premium only.
It is a Premium only feature from the Power BI service perspective. Some of this is due to technical limitations of how SSRS was architected. You can still use paginated reports in SSRS or Power BI Report Server.
So can you connect to a Power BI Data Model? It did not seem to be an option. Will that be available at some point. Ideally, I'd like to be able to link the paginated report to a PBI report where all the slicer options can be ported to the paginated report and it prints out using the pre-filtered Power BI data set.
Not yet. It is coming though. Check out the following doc for a list of current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi
Patrick, nice meeting you at MBAS last week. I believe you did a demo on connecting PBI Report Builder desktop to PBI Service - a existing dataset on premium workspace. Do you have that sample by any chance? thanks. BTW - Enjoy your session especially giving Adam hard time :-)
Thank you!! I tried to read the Microsoft instructions on this but it made no sense. You laid it out perfectly.
I still don’t get it... How is it different from the simple old SSRS?
I think this is the same as the old SSRS paginated reports, just that now its all in one platform, and eventually the Power BI & Paginated reports will be better linked, I guess. I was hoping Power BI features would take over or handle all features of paginated reports.
Hi Patrick, love your videos. I still have a big question I have not been able to answer. Can I execute the paginated report trough an API, sending the parameters and getting back a PDF? Thanks in advance!
Not today. URL Parameter usage is coming soon though. We will definitely have a video on doing this once it is available.
@@GuyInACube thanks for your prompt response. Let's hope we see this soon. 👍
I have tried to upload my RDL files only to get errors, which say to call support. I have tried simple to complex, always the same error.i know this is in preview but I was hoping to try it with some existing reports. All were created with report building and have SQL Server as data source. Looking forward to next video! Love the videos, thanks for all your help here and at your monthly live sessions!
Hi Russ, do you have the paginated reports capability turned on for the workspace you’re looking to upload to? Do you have subreports or any clickthru actions in your reports? Please let me know!
Thanks for watching Russ! Sorry to hear you are hitting some problems. Be sure to get back to Chris's comments. He is the man on this feature :)
I will check to make sure it’s turned on with our admin. I have tried with basic reports, no click through all the way to reports with click through. I assumed we had it turned on but that may be it. Thanks!
Chris, I found our issue, we are splitting the cores dedicated to capacity for certain workspaces, the option isn't available for us. Thanks.
Do you build any data model with the data sets?
As of right now, Paginated reports don't support using Power BI datasets as a data source. It has been stated that will be coming as it gets closer to GA, or maybe shortly after. It is still Preview currently.
Can you show how to do set the store procedures?
Was the walkthrough at [04:35] not enough?
Are data sets tables?
You can think of a dataset within a paginated report as a table. It is the defined query against your data source.
Bruh, this is just SSRS report development.