Forum Discussion
Store the data
Yes i was able to export to exel. Ok many thanks for your help but it is not a good solution form me
thanks but in my PBI file the get data command is deactivated
Well that sucks, you say get Data is greyed out. Is your original import a full model directly from SQL Server Analysis Service model SSAS. I don't use that so I am not familar but I understand that if any changes need to be made, they need to be in SSAS.
Regardless, the screen shot includes the maintenance visual I mentioned. Were you successful exporting it?
Please confirm, you right-clicked on the on the 3 dots (currrently just below the bottom corner of your 2 metrics) and exported the data?
Presuming you can do the export and really still want this. You could build a seperate PBIX file to import to. Certainly not the best solution.
Further, if you are publishing these to the online power BI perhaps you could put a tile from the 2 seperate sources into a single dash.
If this isn't workable you may need to go back to whomever built the model you are getting and discuss what data is available to build a proper roll up, that would allow you to exclude the most recent week from your analysis.
good luck.
Yes i was able to export to exel. Ok many thanks for your help but it is not a good solution form me