User Profile
Elderin
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Power BI embedded on premise or on azure stack?
We've built out a PowerBI embedded solution on Azure for our SaSS application but a very large prospective client requires that we replicate our setup on their premises (they're contractually obligated by their customers to have everything on-premise). Is it possible to run PowerBI embedded completely on-premise? If not directly, what about utilizing Azure Stack?1.3KViews0likes1CommentRe: Embedded Q&A only displays "We weren't able to load suggestions right now. Please try again later."
Hi v-ljerr-msft, Q&A doesn't seem to be available in the PowerBI service itself. It is however working in PowerBI Desktop. I'm currently using import mode and I don't see anything in dataset settings to enable Q&A. Is this feature not available for import mode?3.2KViews0likes2CommentsEmbedded Q&A only displays "We weren't able to load suggestions right now. Please try again later."
I'm unable to get the embedded Q&A feature working, I followed the instructions in this guy in a cube video: https://guyinacube.com/2017/10/embed-power-bi-qa-application/ I set the embed token, embed url, and dataset id in the embedded sample application and clicked run. While the view does load, it shows a "We weren't able to load suggestions right now. Please try again later." message. I can type intot he Q&A box, but no results show. Instead, I get a "We're having trouble finding answers right now. Please try again alter" message. I'm using import mode for my data and I can view and edit embedded reports just fine.Solved3.2KViews0likes4CommentsSpecifying EffectiveIdentity when Retrieving a PowerBI Embedded Report Creation Token
I work for a SaaS company with multiple customer tenants. Each customer has access to their own data but should never see other customer's data. In order to achieve this, I pass the customer's tenant id as the username when retrieving tokens. That tenant id is then used to filter the report data. This seems to work well when embedding existing reports but we also want to allow customers to create their own reports via the embedded interface. However, when I specify the EffectiveIdentity and attempt to retrieve a creation token, I get a "Forbidden" error that states that EffectiveIdentities are not allowed for report creation tokens. Without being able to specify the EffectiveIdentity, I'm unable to filter the data and report creators essentially end up having access to data from all tenants. Is there another way to specify identities for report creation tokens? Please see my current code below (notice how I commented out effective identities when creating the generateTokenParameters). The hardcoded "24" below is the customer tenant id which I'm unable to specify without an error. string roles = "Default"; var rls = new EffectiveIdentity("24", new List<string> { this.AppConfig.PowerBI_DataSetId }); if (!string.IsNullOrWhiteSpace(roles)) { var rolesList = new List<string>(); rolesList.AddRange(roles.Split(',')); rls.Roles = rolesList; } GenerateTokenRequest generateTokenRequestParameters; generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: TokenAccessLevel.Create, datasetId: this.AppConfig.PowerBI_DataSetId, allowSaveAs:true);//, identities: new List<EffectiveIdentity> { rls }); var tokenResponse = await client.Reports.GenerateTokenForCreateInGroupAsync(this.UserSession.CurrentUser.Organization.PowerBIWorkspaceId, generateTokenRequestParameters); // Generate Embed Configuration. model.EmbedConfig.EmbedToken = tokenResponse; model.EmbedConfig.DatasetId = this.AppConfig.PowerBI_DataSetId; model.EmbedConfig.EmbedUrl = string.Format("https://app.powerbi.com//reportEmbed?groupId={0}", this.UserSession.CurrentUser.Organization.PowerBIWorkspaceId);Solved4.9KViews0likes1CommentRe: No PowerBI Create Sample + Forbidden Error
For anyone that has run into this issue, I figured out that the problem is that EffectiveIdentities are not allowed when retrieving tokens for report creation. This does however lead to the next issue where I'm using the effectiveidentity for RLS and not passing it effectively gives access to all data (across all of our customers) when creating reports. I'll create a separate ticket for that.1.3KViews0likes0CommentsNo PowerBI Create Sample + Forbidden Error
Hi all, I've run into some difficulty when trying to add a "create report" option to our "app owns data" website. I was successfully able to implement the view report functionality based on the sample found here https://github.com/Microsoft/PowerBI-Developer-Samples, but I can't find an example of server-side code for allowing end users to create reports. I've set the application's permissions in Azure as detailed here https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-register-app/#apply-permissions-to-your-application. After modifying the code to connect for a create token, I got a "Forbidden" error. Here's the code I'm using: var credential = new UserPasswordCredential(this.AppConfig.PowerBI_ServiceUsername, this.AppConfig.PowerBI_ServicePassword); // Authenticate using created credentials var authenticationContext = new AuthenticationContext(this.AppConfig.PowerBI_AuthorityUrl); var authenticationResult = await authenticationContext.AcquireTokenAsync(this.AppConfig.PowerBI_ResourceUrl, this.AppConfig.PowerBI_ClientId, credential); if (authenticationResult == null) { model.EmbedConfig.ErrorMessage = "Authentication Failed."; return View(model); } var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer"); // Create a Power BI Client object. It will be used to call Power BI APIs. using (var client = new PowerBIClient(new Uri(this.AppConfig.PowerBI_ApiUrl), tokenCredentials)) { string roles = "Default"; var rls = new EffectiveIdentity("24", new List<string> { this.AppConfig.PowerBI_DataSetId }); if (!string.IsNullOrWhiteSpace(roles)) { var rolesList = new List<string>(); rolesList.AddRange(roles.Split(',')); rls.Roles = rolesList; } GenerateTokenRequest generateTokenRequestParameters; generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: TokenAccessLevel.Create, datasetId:this.AppConfig.PowerBI_DataSetId, identities: new List<EffectiveIdentity> { rls }); var tokenResponse = await client.Reports.GenerateTokenForCreateInGroupAsync(this.UserSession.CurrentUser.Organization.PowerBIWorkspaceId, generateTokenRequestParameters); // Generate Embed Configuration. model.EmbedConfig.EmbedToken = tokenResponse; } I would greatly appreciate it if someone could point me towards some sample server side code for the "create report" scenario or tell me what I could be doing wrong above?Solved1.1KViews0likes1CommentDynamic matrix column headers based on user selection
I'm fairly new to power bi but I've done some prior work in Tableau. In my Tableau reports, I was able to create a calculated field (I called it "Period"), which, based on a dropdown selection, would translate a date into its date, week, month, quarter, or year value. I would then use the calculated field as the column header in their matrix. The end result is that by simply selecting daily/weekly/monthly/quarterly/yearly from a dropdown, the user would change the matrix to display data by the selected period breakdown. Does anyone know how to do this in Power BI?Solved3.4KViews0likes2CommentsDynamic Column calculation based on Slicer Selection
I'm fairly new to power bi but I've done some prior work in Tableau. In my Tableau reports, I was able to create a calculated field (I called it "Period"), which, based on a dropdown selection, would translate a date into its date, week, month, quarter, or year value. I would then use the calculated field as the column header in their matrix. The end result is that by simply selecting daily/weekly/monthly/quarterly/yearly from a dropdown, the user would change the matrix to display data by the selected period breakdown. Does anyone know how to do this in Power BI?Solved1.5KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.