How to increase data selection from website by date
Does anyone know how to increase the date selection when pulling data from a website? I am trying to pull bond yield data from the following link to power query. But the default is set to a 1 month time range. Is there a way to change this? How do I adjust this selection to 1 year, 3 years, or 10 years? The M code below is where I believe the answer to my question is. I just don't know how to edit it so that it changes the date selection. let Source = Web.Page(Web.Contents("https://www.investing.com/rates-bonds/chile-10-year-bond-yield-historical-data")), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Price", type number}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Change %", Percentage.Type}}) in #"Changed Type" Thank you for any help on this!Power BI report server Direct query: getting data form one direct query to another direct query
Hi Team, I have 3 tables one with Employee detail(employee ID, Name, Email columns) --> this table accessiable to all. data_access (employee and city) and another table with Country_revenue (Country, continent, revenue amount columns) deatils --> these table is accessible only for specific account when we pass the employee Id in the SQL pacakge(Pkg_data.country_data (Email)) I tried 1. DAX fucntion Userprincipalname to use as a parameter, but direct query (power editor) doesn't support it. 2. list.max but 'Failed to save modifications to the server. Error returned: 'DirectQuery partition 'xxxx-x56565x7575757575x757575' has '2' datasource reference(s) in its expression which is not allowed. '' Can you please help, how to pass Email into this?
Need help transposing a single column of data into 3 columns every fourth cell needs to be a new row
I have something like this: app type record 1 requstor of app 1 requested on 1 app type record 2 requstor of app 2 requested on 2 app type record 3 requstor of app 3 requested on 3 I need it to be like this: App Type Requestor Requested on
Power BI Desktop Optimized for Report Server (May 2022) Error in Power Query & Refresh
Hello, I have installed the version 2.105.961.0 (May 2022) of Power BI Desktop Optimized for Report Server and I have several issues when trying to manually Refresh reports. If, for example, I have used in a merge a query and then decided not to load it in the report, the query with the merged data from the first one gets an error in refresh. Or if I delete the column used in merge (for example when I was trying to create my schema from a flat table and created index columns in Dim Tables and after that merging them with the fact table and deleting the initial columns in order to keep only the foreign key column). I didn't have any issue before the update. If I install the Version: 2.105.1143.0 (May 2022), Released: June 7, 2022 will resolve my issue? And what about the compatibility with the Power BI Report Server installation, do I need to install an update there too? Thank you in advance, Eleftheria
CLYCLICAL WEEKS IN POWERBI/POWERQUERY
Good day, I have a list of weeks of the year and I want to group them into groups of 5, for example: -week 1: 1,2,3,4,5 -week 2: 2,3,4,5,6 The problem I have is that when I get to the last weeks, I wish that when I get to 53, I go back to the beginning, for example: -week 50: 51,52,53,1,2 -week 51: 51,52,53,1,2,3 Is there a way to do it by powerquery? In other words I want the list to be cyclical
Report with multiple connections seems to try to use both in one query?
We have an odd issue; a report with 2 data sources (import mode): Server 1 database A and server 2 database B. Server 1 is UAT and Server 2 is production (but have the same databases A and B), so when the report is published to the Report server, they use different accounts with different privileges. We have some queries created under the datasource for server 1, but which have joins to the database that is specified in the server B datasource; however, as it exists on Server 1, you would expect the query to run only against the databases on Server 1. However, our scheduled refresh is failing saying that the server 1 account cannot access database B - which MUST mean database B on Server 2 (production), as the account would be able to access database B on server 1. I get the same error in PBi Desktop if I use the same credentials as on the server. Is there some oddity within the Power Query model that might do this? i cannot find anyone who seems to have had a similar issue. The error is: Details: DataSourceKind=SQL DataSourcePath=Server 1;Database A Message=The server principal "xxxx" is not able to access the database "Database B" under the current security context. Number=916 Class=14Add a new Column in Power Query
Hi, this is my problem I have 2 Tables "Ventas" and "Reuniones", and my goal is add a column (N° Reunion) in Ventas, i try with Merge Queries, the matching Column beetwen the 2 Tables is "Fecha", the parameter is unique in "Reuniones" and various in "Ventas", but the result at Expand the Merge Queries is only "null", what it´s wrong? or exist another form to do that? Regards
