User Profile
myon
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
PQ Online cache/visual bug? Perpetual loading screen (Datamarts and Dataflow)
Update 2023-05-10, can't author new Flows or Marts anymore: Tried the browser debugger. It complains about 404: An iframe has both allow-scripts and allow-same-origin for its sandbox. 403 on /metadata/artifacts/definitions:1 ERR_HTTP2_PROTOCOL_ERROR on europe.prod.powerquery.microsoft.com/api/trace/message Debugger message: wabi-north-europe-e-primary-redirect.analysis.windows.net/powerbi/metadata/app?preferReadOnlySession=true:1 Failed to load resource: the server responded with a status of 403 () wabi-north-europe-e-primary-redirect.analysis.windows.net/metadata/artifacts/definitions:1 Failed to load resource: the server responded with a status of 404 () web.vendors.min.XXXXXXXXXXXXXXXXXXX.js:1 An iframe which has both allow-scripts and allow-same-origin for its sandbox attribute can escape its sandboxing. K.insertBefore @ web.vendors.min.XXXXXXXXXXXXXXXXXXX.js:1 /cdsaauthoring:1 An iframe which has both allow-scripts and allow-same-origin for its sandbox attribute can escape its sandboxing. ApiRequest.ts:179 POST https://europe.prod.powerquery.microsoft.com/api/trace/message net::ERR_HTTP2_PROTOCOL_ERROR I have also tried these things 1. Check your permissions: Ensure that you have the correct permissions to access Power Query Online and the resources you are trying to access. You may need to contact your administrator to verify your permissions. 2. Clear browser cache: Clearing your browser's cache can help resolve issues that might be caused by cached data. To do this in Microsoft Edge, press Ctrl + Shift + Del, and then select 'Cached images and files' and click 'Clear now.' 3. Disable browser extensions: Some browser extensions can interfere with web applications. Try disabling any extensions you have installed and see if the issue persists. Original message: Upon editing a dataflow from this screen I get stuck in a perpetual loading screen Trying to navigate away from this screen in the UI gives me this error Refreshing the web page through F5 or shift+F5 just brings me back to the first image. How can I solve this? Edit: Additional info Using Edge Version 112.0.1722.68 (Official build) (64-bit) Same issue in Chrome Version 112.0.5615.138 (Official Build) (64-bit) Tried to edit another dataflow I authored 3 months ago, same issue Edit2: I asked our PBI tenant admin two days ago to move our workspace to a capacity that we knew had less load since I thought this was the problem at first. Now, I should double check that this capacity does not have high load as well...but just wanted to say this while I check. Edit 3: Capacity is not overloaded. Edit 4: Firefox could not load either, same behaviour. Collegue could open it on his computer after ownership was transferred. Edit 5: Same issue in Datamarts in the Get Data windowRe: Split rows by days into multiple by dates range
Sorry for a non-answer....but I strongly suggest you solve this as close to source as possible, talking from experience with the same problems to solve. SQL with a recursive common table expression is prefferred. Power Query is possible also. I do not remember exactly how I solved it with DAX. It involved keeping the structure you had in your original table, De Morgan's Law for the problem of overlapping time periods comparing a non-relational calendar with start and stop times for each day and doing subtraction against the end of the day if the periods overlapped. Was super slow and made me realize that this was not the strength of DAX.
