User Profile
jhayes0128
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Authenticated website in Power BI App
I have an internal website that I am trying to add to a Power BI App using the 'Add a link' when updating the Power BI App. This internal website (Azure Web App) has Azure Entra authentication. When using this webapp normally the redirect/callback urls works fine and the user is logged in, however when using from the Power BI App it just says "Unauthorized". Is there a redirect URL I need to add, or better yet since app.powerbi.com already has the authenticated user can i simply retreive that token in my web app to authenticate?Access Field Parameter values in DAX
I have a field parameter referencing 3 different columns. The values inside of those columns are the same. I want to write a measure that says "if GPDCN do something special". Using SELECTEDVALUE or SUMMARIZE on the parameter table just returns the name of the column (like LE_PROXY) but I need the values of that column inside of a measure. How to do this? Field Parameter: The values inside of each column:Enhanced Refresh API doesn't refresh Scorecard/Metrics
I have set up automation to refresh the individual tables inside of datasets when the source table in our data warehouse is refreshed. Our datasets don't need or have a "full refresh". We set up a Metrics Scorecard and found that the values in the Metrics Scorecard only update when there's a "full refresh". How can we have the Metrics Scorecard refresh using the enhanced refresh API? Enhanced refresh with the Power BI REST API - Power BI | Microsoft LearnRe: Dynamic Datasource Error - Retrieving Dataset tables and metadata in the PBI Service
Thank you for the response. I do use RelativePath for calling REST APIs (works great), however there is no REST API endpoint for dataset table names and query definitions. So I need to use AnalysisServices.Database instead of web.contents. There is no RelativePath option on the AnalysisServices.Database connector.Dynamic Datasource Error - Retrieving Dataset tables and metadata in the PBI Service
I have a dataflow in the PBI service that hits several API endpoints to give me tables of all my dataflows, datasets, refresh times, and other metadata. I have an idea to leverage the new Enhanced Refresh API in Power Automate to dynamically refresh my Power BI tables when they're refreshed at the source. My testing shows this is possible, but I need the Dataset table names and M query to make it work. In my dataflow, I am generating a list of my datasets using the REST API. The table looks like this: datasetName Dataset_1 Dataset_2 Dataset_3 Since there is no API endpoint to retrieve the tables/queries, I insert a new step to dynamically insert the datasetName into an AnalysisServices connector to retrieve the tables/queries. AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/MyFakeWorkspace", [datasetName], [Query="select * from $SYSTEM.TMSCHEMA_PARTITIONS", Implementation="2.0"]) This works and returns all of the data I need, HOWEVER i am unable to save this to the service due to 'Dynamic Data Sources'. I use ReferencePath for the web.contents API calls and that works fine (I had the same issue there and this fixed it), but I haven't found a way to get around this one. Per the MS documentation, I could use Power Query parameters but so far I still get the same error. Any ideas? Thank you!White page shadow with dark theme?
I have a report with a custom 'Dark Theme' that works great, however I cannot seem to remove this white shadow between the usable page and the outspace/wallpaper. I do have shadows configured for visuals, but if I change the shadow to red this white shadow stays white. I can't seem to get rid of this white shadow! Any advice? "visualStyles": { "page": { "*": { "outspace": [ { "color": { "solid": { "color": "#252423" } }, "transparency": 0 } ], "background": [ { "color": { "solid": { "color": "#252423" } }, "transparency": 0 } ] } }, "*": { "*": { "dropShadow": [ { "show": true, "color": { "solid": { "color": "#252423" } }, "position": "Inner", "preset": "Custom", "shadowSpread": 10, "shadowBlur": 18.0, "angle": 0, "shadowDistance": 0, "transparency": 65 } ],Play Axis - Cumulative Total Within Selected Date Range
I have a requirement where users want to see daily sales growth by day over a given timeframe. So the user selected 'October 2021' and they can see how sales grow starting from 0 on October 1st. I cannot use ALL since that returns all records from before October. Using any kind of MIN or FIRSTDATE is affected by the play axis I'm using to visualize the growth. How can I make a cumulative measure for the selected date range the user selected, while ignoring the day-by-day increments play axis custom visual performs?
