powerbi

Scraping Data from a website which uses Power BI – retrieving data from Power BI on a website

Putting the scroll part and the JSON aside, I managed to read the data. The key is to read all of the elements inside the parent (which is done in the question): parent = driver.find_element_by_xpath(‘//*[@id=”pvExplorationHost”]/div/div/div/div[2]/div/div[2]/div[2]/visual-container[4]/div/div[3]/visual/div’) children = parent.find_elements_by_xpath(‘.//*’) Then sort them using their location: x = [child.location[‘x’] for child in children] y = [child.location[‘y’] for … Read more

Power BI Embed URL-multiple filters

With the release of 2.0.0 you can now get and set filters at report scope and page scope. We currently don’t support visual scope but it is planned to come in the future. See: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters for more information on how to use the SDK to apply filters. You can also set filters during load. https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details … Read more

Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?

Yes, absolutely! As @David Browne said in his response, it’s just a matter of loading something in a web browser. Generally, it doesn’t matter what are your data sources – SQL Server or flat files, it’s all the same. You can see how it looks like in Power BI Embedded Playground. You have two ways … Read more

Return top value ordered by another column

Another way to do this is through the use of the TOPN function. The TOPN function returns entire row(s) instead of a single value. For example, the code TOPN(1, TableA, TableA[Value]) returns the top 1 row of TableA ordered by TableA[Value]. The Group value associated with that top Value is in the row, but we … Read more