Power Query is fantastic for dealing with troublesome data like flat files, excel files, and web pages (way easier than SSIS), but once I've done the cleanup or mashup, I really want to be able to write it back to the database. Exporting it as a flat file still leaves me with having to write an S...
when you embedded report with multiple pages the page name tab disappeared and will get 1,2.... it is very useful to have tab and name because audience will not figure it is multiple pages report
I have data files available in AWS S3 and I need to read and join them to generate reports in Power BI. Is there a direct or indirect way to read data from AWS S3?
An extremely useful feature in Excel's Pivot Tables the ability to abort a calculation before it's completed by pressing the ESCAPE key. This feature is useful when I accidentally drop a field into the wrong area. Having this feature in Power BI would save me tons of time staring at the sardon...
Active Directory Authentication on a user/group level instead of authenticating a hardcoded single user. Right now, we have to maintain an access list in Power BI, eventhough all access rights is already maintained in our AD. How can we solve this, if we don't want to use Row Level Security or ...
Would like to reuse the Drill Through Actions defined in my SSAS Cubes to "See Records".
I need to pass parameters' from external, wg via url get, to powerbi and put them into direct query. So I can use pbi for operative reporting, eg to push a customer if from crm to a report and pbi must not load initially load all data from the source and I can only load the data that used for th...
Under Manage Parameter, when i use Suggested Values as Query, I would like to set the Current Value to the first item in the query result as the default value when i first open the report. Example: if my query result is a list of dates, i would like to set the latest date as default
Currently in the Power BI service, there are 0 options in date filters outside of selecting date/time and doing "before", "after", "between". Need filters like "Last 7 days" or "Yesterday" or "Last month". This way a user does not need to manually change a filter if they only want to see a report...
Consider last report refresh/update based on GMT as an optional feature in Power BI Service Reports, likewise we get it in the Dataset and Dashboard sections. Today, we have to set a Local.Now () function and, depending on the server's time zone and daylight savings, make calculations to get th...