Dataset in Report Builder returns NULL for values in certain fields
Hello. I have built a query for a dataset in Power BI Report Builder that is pointing at a semantic model in my organization's workspace. I built the query using the desktop program's query editor. It is returning NULL values for a few fields (not all fields) in a table, even though the fields do contain text. I made a paginated report on the online service (clicky-clicky-draggy-draggy method, as Guys in a Cube would say) that is based on the same semantic model, and no such NULL values appear. I have tried to download the .rdl of the report that is working, then import the dataset query into my other report, but it still returns NULL values once it is evaluated in my report. My main questions: 1. Is there another way to move dataset definitions between .rdl files, other than the "Import" button? For example, can I directly copy the .xml code somehow? I found an old forum post that suggested this method, but it seems like it is no longer possible in the latest Report Builder. Should I just do this in Notepad or similar? My other idea was "report parts" but it seems those have been phased out too. 2. Any ideas why my query built on desktop is failing to return values, while the one built in the service is fine? My main clue is that these fields include special characters (the values are text written in Spanish). Or maybe that the field titles include bracket symbols (this is how we distinguish between fields containing English vs. Spanish versions of the same information... e.g. one troublesome field is called "Definition [ESP]" in the semantic model. ). If I can't solve this, I guess I can create every .rdl on the online service first, then modify it on the desktop, but I can imagine many scenarios down the road where this will be problematic. Seems silly that I can't get the query to work when it is built in the desktop app! Thanks!How to authenticate PowerBI Report Server with default user
Hi Team, We are embeding Power BI Server reports (paginated reports \ .rdl files) created using PowerBI Report Builder using IFrame tag in .net application. Currently every use who is logging into .net application has to have an access even on PowerBI Server - otherwise report doesn't show up. As there are many users - we wanted to have this authentication using one default user (AD or System User). Is it possible to authenticate to PowerBI Server using a default user? Any leads here would be greately appreciated. Thanks Mandar