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.
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 ...
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.
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!
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.
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 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
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 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!
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 ?
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.
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, 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).
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.
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?
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!
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?
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.
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, 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!
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 @.
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.
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 :-)
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.
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.
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
