DmsPbiServiceUserException in Datamart
Hi, Getting a "DmsPbiServiceUserException" error when attempting to Save a Import Data Query to a Datamart; Data being sourced from Azure Data Lake Gen 2 with SAS key authentication. Connection to works ok, but fails when saving (above). Any assistance greatly appreciated. Thanks, Magnum
Visualising SQL queries in datamart - how to update the visualisation once the query's been edited
I've started using the PowerBI Datamart to run SQL queries and visualise the results. I've saved these visualisations as reports. I've since edited the underlying query to add/edit some fields. Now, when I go to edit the visualisations fed by this query, the available data doesn't reflect these changes. Only the old fields from my original query are available. Is it possible to refresh the data behind these visualisations, so I can edit them using the latest data from my SQL query? Thanks for the help!db_owner & dms$system.UserQueries
Is it possible to access the db_owner role of a datamart database through SSMS? Even as an admin_user there is no permissions to grant, no extended events and some restricted tables Additionally is it possible to query dms$system.UserQueries? the schema seems to be restricted by defaultDatamart final data set saving option
Hi Team, I have used visual query & created a new data set by merging 2 different tables but how can i save these finally created table.? I didnt see any option of saving, when am connecting from Power BI Desktop, it is showing only 2 data sets. Please find the below screenshot for your reference.Azure Analysis Services Connection to Dataflow or Datamart
Hi, So for some reason I cant connect to Analysis Services when I'm connecting via dataflow or datamart. As of now when I'm in the company building I can connect via "Power BI Desktop" to the Analysis Services. Also I published report and use a gateway the team setup for me. The issue I have is I want to create bunch of Dataflow so I can massage the data so user outside the building can still use the data. Specially working from home. Here are the steps I'm doing let me know if im missing anything or I need to talk to our IT team for a privilage setup or something. So I go to the Workspace > New > Dataflow Then I select Then input the credentials When i click next i get this error : What does this mean? I google the error but I dont get any luck finding a solution. Thanks Chris
