Power bi Rest APi GET request
Hi everyone , Could you please help , i have power bi dashboard that is published in my workspace and have created on streaming db , which it has been connected to, Now my requiremnts are i need to embed power bi in to angular website where we need to give get request to call Power bi rest api to generate report name and provide a report link. we tried giving https://api.powerbi.com/v1.0/myorg/reports but it gives 401 error , what all i need to check so that it can work.
Getting back the report that was made by an older PBI version
I installed the latest PBI Desktop release on a Dev server and still have the main work for the older PBI Desktop release on the Prod server. To check what the new PBI version brings with it, I worked on a report that I changed a bit in the Dev Jan24 (January 2024) PBI - and by mistake saved the work in the same file. Yet, that would not have been so bad since the versions in prod and dev were online, I could have downloaded the Production file to get the old version back. And I could then even work further on the same file, back on the on the Prod server, even though the Prod server is for PBI Sep22 (September 2022). After some time of switching around between Prod and Dev I found it unneeded to take care any longer and worked with the newer PBI. I was not aware (anymore) that by saving the work just one time with the new PBI Desktop, you already update the PBI file to the newer PBI version and cannot go back. I published to the Dev - which worked. I thought that this could also be published to the Prod Sep22 report server. Yet, now that I saved the file on the Jan24 Devevelopment server, it turns out that I cannot publish it to the Production PBI report server anymore. German: > Speicherung in "Power BI-Berichtsserver" wird... > Fehler beim Speichern des Berichts in "Power BI-Berichtsserver" English: > Saving to "Power BI report server" is... > Error saving the report in "Power BI report server" I still need the Sep22-report for the Production report server. I have removed the report in production since I mistakenly thought after that error that I might have to make place for the new file, that there is a problem to override the one that is there. I was plain wrong, now I have dropped the only working production report that was left (since the Dev Report Server and the file are only for Jan24 PBI). Is there a way to get the old 22Sep-report back? Are there any backups on the report server or backups done by Power BI Desktop? Or is there a way to change that 24Jan-report back to a 22Sep-report?Column Query Works sometimes but not for each row.
Hello - I have recently written a query to caulcate service dates for a number of products, they should be serviced anually or twice per year depending on the frequency, within a year of the Start Date. However, I noticed that not all data is populating despite there seemingly being nothing wrong with the code and, in some cases, the information does populate. Here are the codes: PM1 = IF ( ISBLANK ( PM_date_kpo[SVMXC__Start_Date__c].[Date] ), BLANK (), SWITCH ( VALUE(PM_date_kpo[PM_Interval]), -- Convert to Integer using VALUE function 6, DATEADD ( PM_date_kpo[SVMXC__Start_Date__c].[Date], 6, MONTH )-1, 12, DATEADD ( PM_date_kpo[SVMXC__Start_Date__c].[Date], 1, YEAR )-1, PM_date_kpo[SVMXC__Start_Date__c].[Date] ) ) And then: PM2 = IF ( ISBLANK ( PM_date_kpo[PM1].[Date] ), BLANK (), SWITCH ( VALUE(PM_date_kpo[PM_Interval]), -- Convert to Integer using VALUE function 6, DATEADD ( PM_date_kpo[PM1].[Date], 6, MONTH ), 12, DATEADD ( PM_date_kpo[PM1].[Date], 1, YEAR ), PM_date_kpo[PM1].[Date] ) ) for PM3-PM10 the code is the exact same except the reference to the previous PM changes. The table below is a sample output from the query. I cannot understand why sometimes it works and other times it doesn't. From my understanding, as long as Start Date isn't blank, then PM1 - PM10 should populate without issue however as you can see it does not, even when the previous PM has a value. Is there any noticeable issue or way to mitigate this problem? SVMXC__Start_Date__c PM1 PM3 PM4 10/1/2021 9/30/2022 9/30/2024 3/1/2022 8/31/2022 8/28/2023 2/28/2024 3/1/2022 8/31/2022 8/28/2023 2/28/2024 3/1/2022 8/31/2022 8/28/2023 2/28/2024 5/18/2022 5/17/2023
Is there anyway for me to get the Old version Of Power BI (Optimized for report server)?
Hi All, I need a way to download a version of Power BI Desktop (Optimized for Report Server) that is compatible with this version of the report server. Looking on the archive link, the downlaods don't seem to go back far enough. When I try to download it from the report server itself, it redirects me to the download the latest version which is not compatable with the report files on the server. Any help is appreciated. Best, Sam
Install Power BI Desktop (Optimized for Power BI Report Server - May 2022)
Hello, Can someone please help me get an installation file for Power BI Report Server Version: 1.14.8179.37378 (May 2022). This is the Power BI Desktop (Optimized for Power BI Report Server - May 2022). I have looked for days and cannot find the file executable anywhere. When I select the download link within the Power BI Report Server, it takes me to the MS Download Center where downloading Version: 1.14.8179.37378 (May 2022) is NOT an option. Thank you, MS
