I was recently doing some testing with regards to permissions on datasets in the Power BI Service, and I came across two things. First, was that I found I could create access to a dataset where the user’s permission was “Read” I subsequently found that when a user has read permissions to a dataset, they can access it even if...

The post...

How to pass Dynamic Date Parameter into Source Connection in Power BI to extract Data for Multiple YearsSuppose we have the input files(.xlsx) of Sales Orders with Date Range in the file names as shown below:Eg: Sales_Orders_StartDate-20200101 to EndDate-20201231.xlsxNow we wants read the file names having Date range of different years. This can be done...

How to pass Dynamic Year Parameter into Source Connection in Power Query to extract Data for Multiple YearsScenario :Suppose we have the input files(.xlsx) of Sales Orders with Date Range in the file names as shown below:Eg: Sales_Orders_StartDate-20200101 to EndDate-20201231.xlsxNow we wants read the file names having date range of different years. This...

As mentioned in the June and July feature summaries, we are switching a vital component of Power BI from CefSharp to WebView2. We’re making this switch to better optimize our development and release process (which means we’ll be able to spend more time developing new features!). It also means that you’ll automatically get the latest security patches as...