Thanks Patrick for the Dummies like me. Hugs from Brazil :)
@GuyInACube5 жыл бұрын
Most welcome! thanks for watching! 👊
@denwo19824 жыл бұрын
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 ...
@clementngoga3751 Жыл бұрын
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.
@andrecavasotero62345 жыл бұрын
Excellent video. But the best is yet to come in the next videos.
@GuyInACube5 жыл бұрын
Lots of good stuff coming. Thanks for watching Andre!
@the_empress_dej5 жыл бұрын
Thank you!! I tried to read the Microsoft instructions on this but it made no sense. You laid it out perfectly.
@Prateeksha19934 жыл бұрын
How can we set parameters for a paginated report that uses shared datasets?
@georgehouston72562 жыл бұрын
Fantastic stuff, thank you. Please do a walk-through of a connection string for a SharePoint Online List?
@malikmuhammadawais14255 жыл бұрын
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.
@rishabhramchandani23222 ай бұрын
Can we create parameters that auto select things? Such as present date? or Present date -7?
@MehdiRazaToronto Жыл бұрын
Great quick video
@pthapa55 Жыл бұрын
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.
@DennisCaunce Жыл бұрын
can you pass a parameter to the query, when using powerBI as a datasource?
@pankajkishore2257 Жыл бұрын
Can we connect power bi dataset which has been created using import mode.
@vinodreddyyeruva52412 жыл бұрын
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.
@husseinabbas21044 жыл бұрын
Hello patric Please make a video on how to pass multiple parameters to stored procedure in sql server database
@leeperry796910 ай бұрын
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
@kuppireddydamodhar44933 жыл бұрын
Can we call data to power bi using oracle database by writing stored procedure in advanced SQL statement
@devindersingh19514 жыл бұрын
Hi Patrick how to achieve MAT, MAT LY, YTD and YTD LY in Report Builder ..pls suggest
@anhnguyenduy6861Ай бұрын
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.
@nagoorpashashaik84003 жыл бұрын
Any idea how to connect Power BI Paginated Reports with ODBC Support?
@marcelrene88132 жыл бұрын
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.
@peterlapic67613 жыл бұрын
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.
@NishatYasmin5 жыл бұрын
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!
@Dfoliveira254 жыл бұрын
@guy in a Cube, I am having the same problem. Any idea?
@bryanchaves56914 жыл бұрын
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!
@vinaljain4 жыл бұрын
HEY !! Thank you for the informative video By the way is it possible to apply page break on a Column chart .?
@ruchikasoni31924 жыл бұрын
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?
@triparnaray4 жыл бұрын
Hi Patrick,thanks for that. any pointer to get datepicker for from date and to date in paginated report.
@David-yq6un5 жыл бұрын
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!
@DJCousinRandy5 жыл бұрын
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.
@GuyInACube5 жыл бұрын
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.
@sushiljagtap2174 Жыл бұрын
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 ?
@adeabraham1263 жыл бұрын
paginated report: can I change the data source for a similar data source to keep the same report?
@CSteinberg034 жыл бұрын
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?
@billfarmwald80342 жыл бұрын
Can Power BI Data Flows be used to create paginated reports in Power BI Report Builder?
@christiannoackaguila93624 жыл бұрын
Hi! Which reproduction list would you recommend to get first steps into Power BI?
@Ibraheembinmehmood4 жыл бұрын
Hi, I want to use Excel as my data source. Can we connect Report Builder to Excel?
4 жыл бұрын
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.
@djpirra4 жыл бұрын
Shared connections is already supported today?
@guguli195 ай бұрын
How to execute a PBI paginated report when any one data source is not accessible
@pauldongallo23594 жыл бұрын
How about the Data source from excel? is not possible on Power BI Report Builder?
@gopichand57173 жыл бұрын
Can we connect to our dataset to create paginated reports
@livings40865 жыл бұрын
is anyone using or know if you can PowerBI datasets in report builder?
@mustafabiviji007115 жыл бұрын
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).
@GuyInACube5 жыл бұрын
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?
@thesoothingbutterfly96145 жыл бұрын
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.
@amrutaallundi98514 жыл бұрын
Can you please help with scheduling gateway refresh of paginated reports ?
@GuyInACube4 жыл бұрын
You don't schedule a refresh on a Paginated report. You schedule refresh on a dataset or dataflow.
@victorhuang54855 жыл бұрын
Could this report publish to Power BI Report Server On-Premise?
@michalgebala32425 жыл бұрын
hello does those type of reports supports data gateway integration?
@mnelson100005 жыл бұрын
So this will not be available in Power BI Desktop...? Seems like another Access or SSRS retread
@RichardParsons654 жыл бұрын
Yeah - just SSRS tagged onto Power BI. Good for the Power BI Service to show list reports, as well as just visualisations.
@sqwale75 жыл бұрын
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.
@hiteshsingh15193 жыл бұрын
can please share credentials of the file which you have shared on github
@marklund74985 жыл бұрын
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?
@BigTerrick5 жыл бұрын
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 @.
@Karenshow5 жыл бұрын
Can you show how to do set the store procedures?
@GuyInACube5 жыл бұрын
Was the walkthrough at [04:35] not enough?
@russsauers5 жыл бұрын
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!
@cfinlan5 жыл бұрын
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!
@GuyInACube5 жыл бұрын
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 :)
@russsauers5 жыл бұрын
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!
@russsauers5 жыл бұрын
Chris, I found our issue, we are splitting the cores dedicated to capacity for certain workspaces, the option isn't available for us. Thanks.
@brentlightsey7835 жыл бұрын
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?
@GuyInACube5 жыл бұрын
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.
@rudnickj5 жыл бұрын
I was trying to follow along locally, but don't have a login or password for the demo data :(
@GuyInACube5 жыл бұрын
You would need to have the AdventureWorks database in some database server. Then use the credentials for the server you put it on.
@paorodma5 жыл бұрын
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!
@GuyInACube5 жыл бұрын
Not today. URL Parameter usage is coming soon though. We will definitely have a video on doing this once it is available.
@paorodma5 жыл бұрын
@@GuyInACube thanks for your prompt response. Let's hope we see this soon. 👍
@tabithab7911 ай бұрын
Q: can you show me how to publish.rdl files to power BI
@1spunch3 ай бұрын
Cool
@corydwagner5 жыл бұрын
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.
@GuyInACube5 жыл бұрын
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.
@pukashell61705 жыл бұрын
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.
@GuyInACube5 жыл бұрын
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
@buuutruong94945 жыл бұрын
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 :-)
@mshparber5 жыл бұрын
I still don’t get it... How is it different from the simple old SSRS?
@mustafabiviji007115 жыл бұрын
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.
@Karenshow5 жыл бұрын
Do you build any data model with the data sets?
@GuyInACube5 жыл бұрын
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.
@ricardoabella8673 жыл бұрын
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
@iseron4 жыл бұрын
this guy started a company since microsoft employe?
@Karenshow5 жыл бұрын
Are data sets tables?
@GuyInACube5 жыл бұрын
You can think of a dataset within a paginated report as a table. It is the defined query against your data source.